Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi,
Try this:
=REPLACE(LTRIM(replace(Column, '0', ' ')),' ',0)
Hope it helps!!
Hi,
Try this:
=REPLACE(LTRIM(replace(Column, '0', ' ')),' ',0)
Hope it helps!!
Hi Yarin,
Try,
Num(FieldName) (If your field is text then try => Num(Num#(FieldName,'#')) )
or
=Replace(Ltrim(replace(FieldName,'0',' ')),' ','0')
thanks' it's good.
yarin.
I am glad to help!!