remove leading zero in numeric field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I remove leading Zeros in numeric fields that are less than 1.000?

example, 0.123, I would like to have .123.

Thanks

Gary
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

removing leading zeros in numeric fields 3
Need to flag the lead ID of any contiguous ID's from a sorted list of ID's. 5
Update this macro to make it generate a counter as text 7
Adding leading zeros 3
How can I remove leading zeros? 17
Handling hhmmss time format 6
Using column with numbers and leading zeros 2
Copying numeric text with leading zeros 3

Back
Top