number format

G

Glenn

How can I get 1 to show up as 01 yet still be considered a number? I can
only get it to show up as 01 by changing the format to text.

I want a list like this:

01
01
03
04
05
06
07
08
09
10
11
12

etc, going no higher than 99 (which if that were the case I'd want 001).

Thanks.
 
S

Stopher

Go to Format cells and Custom and in the Type: type 00 or for how many
numbers you want to fill.

Stopher
 
E

EasyPC Training

Hi Glenn

Type the number "1" in a cell. Go to Format > Cells > Custom. In the 'Type'
text box type "00" (i.e. zero, zero) then OK. The cell should then display
"01". If you AutoFill this number series, it will automatically set all the
numbers as 2 digits.

Similarly, if you want to display the number "001" you type "000" in the
custom 'Type' text box.

Hope this helps ! Penny
www.easypctraining.com.au
 
Top