MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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?



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

goto Format/Cells/Custom and type in:


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.