software

I enter the numbers quot;06-9832quot; which are then automatically changed to
quot;Jun-32quot;. Why and how do I turn off this function / formatting?

Many thanks!

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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;OldFatDogquot; gt; wrote in message
news
gt; I enter the numbers quot;06-9832quot; which are then automatically changed to
gt; quot;Jun-32quot;. Why and how do I turn off this function / formatting?
gt;
gt; Many thanks!

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

Format gt; Cells gt; Number ==gt; Text

HTH

Bruce--
BruceP
------------------------------------------------------------------------
BruceP's Profile: www.excelforum.com/member.php...oamp;userid=33653
View this thread: www.excelforum.com/showthread...hreadid=536901