Removing leading zeros

[Ron Cates]

I am looking for a calculation to use in conjuction with replace field contents to remove all leading zeros from a number in a field?

Thanks

Edited September 30, 2010 by Guest
ID Field Type

[David Jondreau]

Is the only data this field holds a single number? If so, you can change the field type to Number and that will remove all zeroes.

If there's other text in there...you'll need to get tricky. How tricky depends on whether there is more than one number in the field you need to adjust.

[TheTominator]

GetAsNumber(theField)

[Ron Cates]

Problem solved. I just used GetAsNumber(MyField) and it worked just fine.

The field was originally text but I changed it to a number field. The old data had the leading zeros that needed to be removed.

Thanks

[Lee Smith]

Hi Ron,

A way better description of your need.

Lee