How to Allign data in a column to Right or Left ?

[#1]

Hi All,

I am facing the following problem . I have a column named Value and the data is placed in the Value Column as following .

How can I allign the data in the Value column to right . Please share if any functions available . I want to do it in the backend and use the column .

Value
2
3
4
5
1
2
3
4
5
6

Thanks in Advance ..

Regards,

Chakravarthy.

[#2]

I think you can do that using macro..

but why do it in the backend if you can set that in the property setting of the table??

[deepakk]

Hi,

use num(trim(Value)). I think this will help you.

use num only if it is a number field.

[#4]

Hi Mongkz & Deepak ,

Thanks for your reply . Actaully it is the data issue .Rectified it at the database level ....

Regards,

Chakravarthy.