HELP - to enter numbers 001, 002, 003 into cells

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Pointer - 30 Jun 2004 06:57 GMT

I want to enter numbers from 001 to 999 into cells formatted as text.
How can I without typing 001, 002, 003, etc individually into each
cell?

Reply to this Message

JE McGimpsey - 30 Jun 2004 07:02 GMT

Format column A as Text. In A1, enter 001. Drag the fill handle down as
far as necessary - XL will increment the number.

> I want to enter numbers from 001 to 999 into cells formatted as text.
> How can I without typing 001, 002, 003, etc individually into each
> cell?

Reply to this Message

Pointer - 30 Jun 2004 07:59 GMT

I knew the trick but never though it would work in cells formatted as
text. Thanks JE.

Pointer

------

>Format column A as Text. In A1, enter 001. Drag the fill handle down as
>far as necessary - XL will increment the number.
>
>> I want to enter numbers from 001 to 999 into cells formatted as text.
>> How can I without typing 001, 002, 003, etc individually into each
>> cell?

Reply to this Message