If I wanted 5-7 to mean May 7th, I would type "May 7th"
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/comm...excel.newusers |
If I wanted 5-7 to mean May 7th, I would type "May 7th"
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 |
All times are GMT +1. The time now is 11:28 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com