feild num without zero

[Anonymous]

hi,

i have feild with 6 numeric position.

in some case the num start with zero.

exm:

000353 = 353

003303 = 3303

061498 = 61498

000101 = 101

....

how do i chenge it to numeric feild without the zero at start?

thanks'

yarin.

[Anonymous · Accepted solution]

Hi,

Try this:

=REPLACE(LTRIM(replace(Column, '0', ' ')),' ',0)

Hope it helps!!

[tamilarasu]

Hi Yarin,

Try,

Num(FieldName)  (If your field is text then try  =>  Num(Num#(FieldName,'#')) )

or

=Replace(Ltrim(replace(FieldName,'0',' ')),' ','0')

[Anonymous]

thanks' it's good.

yarin.

[Anonymous]

I am glad to help!!