number ZERO in a cell

Posted to microsoft.public.excel.programming

No Name

Posts: n/a

number ZERO in a cell

hi,

I have a cell that i want a user to enter a number into.
BUT... u know how if you enter '0123' it will change it
to '123' ... how can i KEEP the '0' at the beginning of
the number

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
Copying the number of a custom formatted number cell	fbvideo	Excel Discussion (Misc queries)	2	January 25th 07 11:00 PM
Random cell/number and dont repeat selected cell/number	Hector PR	Excel Discussion (Misc queries)	0	October 16th 06 05:02 PM
formatting cell number based on previous cell number	Pasquini	Excel Discussion (Misc queries)	3	June 20th 06 06:36 AM
Count number of times a specific number is displayed in a cell ran	subs	Excel Worksheet Functions	1	June 27th 05 05:01 PM
command to return the row number or cell number in excel?	desmondleow[_5_]	Excel Programming	1	December 11th 03 10:51 AM

All times are GMT +1. The time now is 05:39 PM.

Menu

About Us