J. Gutierrez

Posts: n/a

How to display numbers as 000, 001, etc.

Quick question for everyone...

How do I enter numbers with format 000, 001, 002, etc? I also need to be
able to "drag" the cells down to get me all the way to 999.

Any suggestions?

Thanks,

JG

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
HOW DO I DISPLAY NUMBERS AS WORDS IN EXCEL 2003?	Silvio	Excel Discussion (Misc queries)	3	July 29th 05 08:21 PM
How to display zero in numbers?	breeze	Excel Worksheet Functions	5	January 10th 05 08:24 PM
entering numbers to display a time format	Ian Williams/Eazygig	Excel Discussion (Misc queries)	1	January 10th 05 11:57 AM
Sorting when some numbers have a text suffix	confused on the tundra	Excel Discussion (Misc queries)	5	December 18th 04 10:19 PM
finding common numbers in large lists	Jenn	Excel Worksheet Functions	1	November 11th 04 07:42 PM

All times are GMT +1. The time now is 09:18 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us