Number Formats
Posted by John on November 12, 2001 1:33 PM
I'm trying to use a list of numbers that range in value from 1 to 9999 and I right now they are showing as a value. How can I change properties to a text property and validate it so that it will return with a 0001 if my stock number was a 1?
Thanks,
John
Posted by Barrie Davidson on November 12, 2001 1:40 PM
If you want to keep the numbers as a number (rather than text), just custom format the cells to "0000".
BarrieBarrie Davidson
Posted by faster on November 12, 2001 1:47 PM
you can use a custom number format to see leading
zeros
goto Format/Cells/Custom and type in:
0000
Posted by Mark W. on November 13, 2001 6:11 AM
Convert your numeric values to text in an adjacent
column using =TEXT(< ref >,"0000") where < ref >
is a cell reference, and then Copy/Paste Special
Values. After the Copy/Paste format the new
cell range as Text.
