| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date in cell keeps adding the current year.
The date in the cell keeps adding the year when I don't want it to, even if I
select "Category - Date" and "Type - 3/14". I need to have ONLY the month and day (2 digits each in the date format so it's sortable), not the year, but the year keeps appearing after the date in the formula bar. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Year-to-date based on current month | Excel Discussion (Misc queries) | |||
| Date not defaulting to current year | Excel Worksheet Functions | |||
| Date defaults to current year | Excel Discussion (Misc queries) | |||
| 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 | |||
Threaded Mode
