| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
When typing dates do not default to current year.
I used to (with my old computer) be able to type in "Jul 5" as an example,
and have Excel populate the cell with the current year "Jul 1, 07" ie. fill the year. With my new computer, it fills this input as "Jul 1, 01" Any ideas on how I can get the current year to populate automatically? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Converting Older Dates to Current Year | Excel Worksheet Functions | |||
| Combination Graph with current year and prior year sales | Charts and Charting in Excel | |||
| how do I convert a dates in a year quarters in a 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 | |||
![Spreadsheet Geek[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
