Hi All,

I have a text field ... 270123 ..when I convert to number using texttonum then I got 27123. Because I would like to get next number of it by increasing 1 then I would like to have 270124 ...Is there a way to get from text to number by having 270123 instead of 27123 ?

Thanks

What I mean by this is when in text ... 0123 ..when converting to number is 123 ...is there a way to convert as it 0123 as a number?

Thanks

Numbers can't have leading zeros. But you can do this:

TextToNum(27 & 0 & 123)

... or:

TextToNum(field1 & 0 & field2)

Does that help?

it seems a simple typo here.

TexttoNum(270123)=270123

TexttoNum(27O1213)=27123 8That's an "O" like in "One"

"TexttoNum(27O1213)=27123 8That's an "O" like in "One""

I think you figured it out, as the poster didn't mention two fields. There might be a 2 typos in you answer though.

Lee

Thanks All,

I got it from all your answers .

Thanks

Anh Tran