How can I save with zeros left?

Hi guys
Here again, I have this problem
In the fields I can put leading zeros, but when I save the record the zeros have been removed

Any suggestions, thanks

LeviP_0-1682439659051.png

 

0 4 259
4 REPLIES 4

If you need to control a certain formatting of the data (retain leading zeros), you will need to use the TEXT column type instead of NUMBER.

Yes, I'm doing it, only in other cases it's time to convert these texts to numbers

Thank you

Let's back up for a second.  I was curious and tested.  I am finding that if you set the Digits value, it will fill in the number with leading zeros.  It doesn't show that way when entering the value but will on display after save.  See images below.

 

If the digits setting doesn't fully handle you need, then it may be that saving as TEXT is the way to go.  There is also a NUMBER() function which will allow you to treat a Text value as a Number so you can use it in calculations when needed.

Entering "123" in Number Test field

Screenshot 2023-04-26 at 9.37.50 AM.png

Displayed result after Saving "123"

Screenshot 2023-04-26 at 9.38.03 AM.png

Editing "123" by adding "45" to the beginning

Screenshot 2023-04-26 at 9.38.21 AM.png

Displayed result of "45123"

Screenshot 2023-04-26 at 9.38.30 AM.png

Thank you,

The problem I have is: In excel, numbers with leading zeros are not saved with numeric fields

With text-type fields, no problem, but when doing calculations it's more complicated

Top Labels in this Space