Posted to microsoft.public.excel.misc

ctjakkals

Posts: n/a

How do I display 0 in eg 021796 - not as text?

How can I display the leading 0 in a number without having to change the cell
format to text? eg yymmdd 010115?

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 the "ampersand" in the header as text	Mark10101010	Setting up and Configuration of Excel	1	May 15th 06 04:01 PM
wrapped text does not display	Erik	Excel Discussion (Misc queries)	6	February 21st 06 10:06 PM
Formulas dealing with text data	Bagia	Excel Worksheet Functions	6	June 20th 05 10:29 PM
In Excel how can a number automatically display in text form	Curtis A	Excel Worksheet Functions	2	February 26th 05 11:31 AM
Sort or Filter option?	Mcobra41	Excel Worksheet Functions	3	February 23rd 05 07:22 PM

All times are GMT +1. The time now is 10:22 AM.

About Us

"It's about Microsoft Excel"