I'm new to Excel 2007. My problem is that I do not know how to stop Excel
from automatically converting text to a date format. For example, when I
enter data in a cell such as: Smith v Jones 06-91, Excel automatically
changes 06-91 to Jun-91. Data entered as Smith v Jones 06-3412 remains
06-3412. How do I stop Excel from automatically changing 06-91 to Jun-91?
"06" does mean June but it should stay as "06".

Thanks.

How do I stop Excel from automatically changing 06-91 to Jun-91?
You can either precede the input: 06-91 with an apostrophe ('),
or pre-format the input cells as text beforehand.

.. when I enter data in a cell such as: Smith v Jones 06-91,
Excel automatically changes 06-91 to Jun-91.
I don't know/have xl2007, but think the above doesn't happen in xl2003 (my
ver)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Ann" wrote:
I'm new to Excel 2007. My problem is that I do not know how to stop Excel
from automatically converting text to a date format. For example, when I
enter data in a cell such as: Smith v Jones 06-91, Excel automatically
changes 06-91 to Jun-91. Data entered as Smith v Jones 06-3412 remains
06-3412. How do I stop Excel from automatically changing 06-91 to Jun-91?
"06" does mean June but it should stay as "06".

Thanks.