Enter '0001 in A1 Note the apostrophe.

Type A1:A2400 in namebox and ENTER.

EditFillSeriesAutofill


Gord Dibben MS Excel MVP

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

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.