Leading Zero & Apostrophe - Help

  • Thread starter Thread starter Yvonne
  • Start date Start date
Y

Yvonne

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
 
I know you want to do this with the apostrophe but you need to ensure the
cells are formatted General before you begin.
best wishes
 
Back
Top