How can I save with zeros left?

[LeviP]

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

[WillowMobileSys]

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.

[LeviP]

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

Thank you

[WillowMobileSys]

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

Displayed result after Saving "123"

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

Displayed result of "45123"

[LeviP]

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