Apple Event: May 7th at 7 am PT
I am trying to input numbers such as 001, 002 etc. but the 00's in front keep getting dropped. I understand putting them there does not make this true or real numbers but I need them in this table. How do I get this without the 00's being dropped?
Numbers
I finally figured out how to automate the second argument of Barry's =RIGHT("00000000"&B2,9) to take the guesswork out of padding enough to accommodate the largest number in a column B:
= RIGHT("000000000000"&B2,LEN(MAX(B))+1)
Very simple, really, after realizing I couldn't do MAX (LEN...) but I could do LEN(MAX...).
SG
Help with Numbers. I am trying to input numbers such as 001, 002 etc.
