View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Yvonne Yvonne is offline
external usenet poster
 
Posts: 26
Default Leading Zero & Apostrophe - Help

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
nothing has changed
How do I turn it back on?
Please don't advise me to Right Click Format Cells, I want to be able to use
the apostrophe '07
I am using Excel 2003 on Windows XP
Thanks in advance