| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
default year
I have a list of dates (mm/dd) in a column. I have formated the cells to
display mm/dd and this works, however, if you double click on the date it displays the year. I added most of these different dates in 2007 and I am now entering more. When I sort them by date, the ones I recently entered (2008) are at the bottom when what I want is them mixed in with the others. How do I get it to NOT acknowlegde the year? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Default entry to year other than current | Excel Discussion (Misc queries) | |||
| Enter day, default month and year | Excel Discussion (Misc queries) | |||
| When typing dates do not default to current year. | Excel Worksheet Functions | |||
| Combination Graph with current year and prior year sales | Charts and Charting in Excel | |||
| How to compare current year to prior year in bar chart? | Charts and Charting in Excel | |||
Threaded Mode
