View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Chip Pearson
 
Posts: n/a
Default Excel - I type 9-6 in cell and it automatically changes to 9 June

Format the cell as Text prior to entering the text, or precede
the text with an apostrophe ('). The ' will not show in the cell,
but will in the formula bar.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"fevans" wrote in message
...
When I type numbers into an excel cell they automatically
change to a date
and I want the numbers not a date.
How do I save my own entry?