Removing the leading zeros

[cunner26]

Hello,

I am looking to remove leading zero's from employee numbers. The employee numbers do not always start at the same area, ie. an employee number can be 0005656 or 012343.

How can I just get rid of the zero's that come before the number.

Thanks for your help,

 

[IdoMillet]

You can simply convert it to a number
---------------------
CDbl({your_string})
---------------------
Then, format this formula to have no decimals and no thousands separator.

hth,
- Ido CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com