Help

Re: Why Number fields keep removing the leading number zero?

441 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Xing
6 - Interface Innovator
6 - Interface Innovator

I have a number field, no formula related, just simple number field. I have been trying to type 0210, it shows 210 instead, the leading "0" is automatically missing, is there anyway that I can keep the 0? thanks

1 Reply 1
Sho
11 - Venus
11 - Venus

Leading zeros are removed in number fields.
You may use the Single line text field.

Or use this formula to convert a number field.

REPT("0", 4-LEN({Number}&"")) & {Number}