How do I change number formating to start at 0001?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Every time that I try to change the number format I can only start at 01. I
must start my numbering at 0001 and shy of manually typing in every number (
I need 2400) I don't know how to do it. Can anyone help? Thanx.
 
Click on the column header letter where you want your list.
Format > Cells > Number Tab
In the left panel highlight 'Custom'.
On the right, where it says Type: type 0000, click 'OK'
In the first cell of your column type 0001,
With this cell highlighted, Edit >Fill > Series.
Dot in Column, Step value: 1, stop value 2400. click 'OK'

(Try it on a copy of your file first).

George Gee
 
Enter '0001 in A1 Note the apostrophe.

Type A1:A2400 in namebox and ENTER.

Edit>Fill>Series>Autofill


Gord Dibben MS Excel MVP

On Mon, 12 Nov 2007 13:46:00 -0800, Rita and Matt <Rita and
 
Hi Rita & Matt,

If you go into Format/Cells/Numbering and then select Text it will allow you
to type anything. Type in 0001, next cell down or across or where ever you
need it to be & type 0002. Highlight both cells. At the bottom of the
second cell will be a little knob that you can pull down and it will then
create all the numbers up to what ever you need. You can then align the
cells to suit your needs.

Hope this helps

Cheers
Donna
 
Back
Top