Worksheet/table entered numbers are rewritten!
 

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!

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!

Worksheet/table entered numbers are rewritten!
 

You can change the format of the cell to "Text", if you're application
will allow you to treat those numbers as text strings.

Format Cells Number == Text

HTH

Bruce


--
BruceP
------------------------------------------------------------------------
BruceP's Profile: http://www.excelforum.com/member.php...o&userid=33653
View this thread: http://www.excelforum.com/showthread...hreadid=536901