Posted to microsoft.public.excel.misc

Yvonne

external usenet poster

Posts: 26

apostrophe and leading zeros

When entering 07 I put an apostrophe in front to ensure the leading zero
stayed in place. For some reason I can't do this now when I put an
apostrophe in front in makes no difference, so I get 7. To my knowledge I
haven't changed anything.
How do I turn it back on?
Thanks in advance

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
Leading Apostrophe	[email protected]	Excel Worksheet Functions	3	September 10th 08 07:36 AM
Leading Zeros	[email protected]	Excel Discussion (Misc queries)	6	August 3rd 06 06:15 PM
iNSERT LEADING APOSTROPHE	uncreative	Excel Discussion (Misc queries)	3	March 30th 06 12:57 AM
Leading Zeros	Karen	Excel Discussion (Misc queries)	3	January 10th 06 09:50 PM
save text field w/ leading zeros in .csv format & not lose zeros?	Ques	Excel Discussion (Misc queries)	1	May 4th 05 06:21 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us