PC Review


Reply
Thread Tools Rate Thread

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

 
 
Pointer
Guest
Posts: n/a
 
      30th Jun 2004
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 With Quote
 
 
 
 
JE McGimpsey
Guest
Posts: n/a
 
      30th Jun 2004
Format column A as Text. In A1, enter 001. Drag the fill handle down as
far as necessary - XL will increment the number.

In article <(E-Mail Removed)>,
Pointer <(E-Mail Removed)> wrote:

> 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 With Quote
 
 
 
 
Pointer
Guest
Posts: n/a
 
      30th Jun 2004
I knew the trick but never though it would work in cells formatted as
text. Thanks JE.

Pointer

------

On Wed, 30 Jun 2004 00:02:08 -0600, JE McGimpsey
<(E-Mail Removed)> wrote:

>Format column A as Text. In A1, enter 001. Drag the fill handle down as
>far as necessary - XL will increment the number.
>
>In article <(E-Mail Removed)>,
> Pointer <(E-Mail Removed)> wrote:
>
>> 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 With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
If I type in 3, I get .003 after hitting enter. All .xls files. =?Utf-8?B?U3R1?= Microsoft Excel Misc 2 10th May 2006 02:04 PM
Mdac 2.8 Update and MS04-003 =?iso-8859-1?Q?Jean-S=E9bastien_Frerot?= Windows XP General 1 8th Jul 2004 04:36 AM
HELP - to enter numbers 001, 002, 003 into cells Pointer Microsoft Excel Discussion 0 30th Jun 2004 06:59 AM
MDAC-Patch (MS04-003) Rudi Windows XP Security 6 30th Jan 2004 08:11 AM
Help! Help! Help! Help! Help! Help! Help! Help! Help! Help! Help! Help! Help! -$- Windows XP Internet Explorer 2 21st Dec 2003 11:45 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 05:23 AM.