Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi,
If you enter a 2 part date with only a 2 digit year then excel will presume you mean month/day and automatically inputs the current year to the date.....try specifying the year with 4 digits. HTH Jean-Guy "Pam Watts" wrote: I am trying to enter dates in an excel sheet, showing them as month/year. June, 2008 would show as 06/08. No matter what format I use, the year in my entry is changed back to the current year, or 6/07. What am I doing wrong? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Sick time accumulation | Excel Worksheet Functions | |||
Display DATE in alt column | Excel Discussion (Misc queries) | |||
changing the year of a date | Excel Worksheet Functions | |||
NETWORKDAYS - Multiple Date Selection | Excel Discussion (Misc queries) | |||
how do I make a word typed in a cell go to a specific cell in anot | Excel Discussion (Misc queries) |