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, 201015 yr by Guest
ID Field Type

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.

GetAsNumber(theField)

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

Hi Ron,

A way better description of your need.

Lee