Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date defaults to current year
The date format is set to "Mar-01", and when the date is entered in any of
these formats: "Mar-08", "Mar 08", "3/08", "3-08" it defaults to "Mar-07". If we use the format: "Mar-2008" or "Mar 2008", or "3/2008" or "3-2008" it comes out "Mar-08". Obviously, I could just instruct my staff to use the latter versions, but it seems silly that we can't force the spreadsheet to work. Any ideas how to fix this? -- cmaddox |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combination Graph with current year and prior year sales | Charts and Charting in Excel | |||
calculate prior calendar year end from a moving current date | Excel Worksheet Functions | |||
days since 1/1/current year | Excel Discussion (Misc queries) | |||
Current year function | Excel Worksheet Functions | |||
How to compare current year to prior year in bar chart? | Charts and Charting in Excel |