| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date Settings
I was wondering if someone could tell me how to change the date settings.
When I type month-year (eg-Sept-01) into a cell, it automatically gets converted to 1-Sept and I cannot make a chart with month-year as a result. How would I go about changing this? Any help would be great... |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Date Settings
Highlight the desired cells...
Got to Format-Cells Select Date, and select the one that shows Mar-98. That should do it... "Berger" wrote: I was wondering if someone could tell me how to change the date settings. When I type month-year (eg-Sept-01) into a cell, it automatically gets converted to 1-Sept and I cannot make a chart with month-year as a result. How would I go about changing this? Any help would be great... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I create a schedule from a list of dates ? | Charts and Charting in Excel | |||
| Excel 2007 Date Format Problem | Excel Discussion (Misc queries) | |||
| excel date scheduling not msProject | Excel Worksheet Functions | |||
| How to return a value between date ranges | Excel Worksheet Functions | |||
| count between start date and end date | Excel Discussion (Misc queries) | |||
Linear Mode
