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
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
Displayed result after Saving "123"
Editing "123" by adding "45" to the beginning
Displayed result of "45123"
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
User | Count |
---|---|
18 | |
13 | |
8 | |
4 | |
2 |