| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date in cell keeps adding the current year.
hi
does the date appear as 4/10 in the cell? if so then everything is normal. fomating changes the way the data looks. it does not change the data. what appears in the formula bar is what is in the cell such as a fomula. the formula appears in the formula bar and the results appears in the cell. in your case, the formated version of the date would appear in the cell but the full date would appear in the formula bar. Regards FSt1 "Excelsior731" wrote: 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
