Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#3
Posted to microsoft.public.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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data type auto convert | Excel Discussion (Misc queries) | |||
Pivot Chart: cannot apply the default chart type... | Charts and Charting in Excel | |||
Can I set the numerical type of Cell to Hex format | Excel Discussion (Misc queries) | |||
Adding a line Chart Type to a stacked-clustered Chart Type | Charts and Charting in Excel | |||
Convert data of cells to any type: Number, Date&Time, Text | Excel Discussion (Misc queries) |