Add Leading Zeros and format as number 1

[YANKRAY]

CR 10.0

I have a field (string) that I need to convert to a number, but also have leading zeros.

For Example:

String:
99
101
8888
123456

Convert to number:
000099
000101
008888
123456

Any suggestion?

thanks,
Ray

 

[dgillz]

By definiation 000099 is not a number, it is text. Making it look this way is easy:

Totext({yournumberfield},"000000")

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"If you have a big enough dictionary, just about everything is a word"
--Dave Barry