Change Date Format

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ann - 29 Dec 2007 06:44 GMT

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.

Reply to this Message

Max - 29 Dec 2007 09:32 GMT

> 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)

Signature

Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

> 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
[quoted text clipped - 4 lines]
>
> Thanks.

Reply to this Message

Rate this thread: