View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips
 
Posts: n/a
Default Worksheet/table entered numbers are rewritten!

Precede it with a single apostrophe, ', or format the cell as text.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"OldFatDog" wrote in message
...
I enter the numbers "06-9832" which are then automatically changed to
"Jun-32". Why and how do I turn off this function / formatting?

Many thanks!