If I wanted 5-7 to mean May 7th, I would type "May 7th"

[Adam Carlson]

I dont understand why a non-pro user at excel has to go searching for a way
to turn this function off. Does Microsoft not care about those of us who
dont use Excel on a everyday-forwork-basis?

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...32ec13de69&dg=microsoft.public.excel.newusers

 

[Peo Sjoblom]

I agree that it is stupid. Don't know if you know this or not but you can
precede the entry with an apostrophe or format the cell(s) as text prior to
entering the data

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey

 

[Bondi]

Hi,

A workaround would be to format the cells as Text (Right click cell ->
Format Cells -> Number and chose Text) If you do this befor you enter
5-7 then it should stay as 5-7

Regards,
Bondi