| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
formatting a cell to display the correct date.
I want to format a cell to automatically display the current year with only
inputting the current date. For example, I want the cell to display " Thursday, Feb 23, 2006 " when I type in "Feb 23" or just "2/23". I had formatted the cell to do this but for some reason the program thinks the year is 2004. I know the time and date on my computer are correct. The worksheet I am trying to use was created in 2004. Does that have something to do with my problem? Please help. -- Lee Davenport |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
formatting a cell to display the correct date.
Check Tools Autocorrect to see if there is an entry to replace 2006 with
2004... Vaya con Dios, Chuck, CABGx3 "Lee" wrote: I want to format a cell to automatically display the current year with only inputting the current date. For example, I want the cell to display " Thursday, Feb 23, 2006 " when I type in "Feb 23" or just "2/23". I had formatted the cell to do this but for some reason the program thinks the year is 2004. I know the time and date on my computer are correct. The worksheet I am trying to use was created in 2004. Does that have something to do with my problem? Please help. -- Lee Davenport |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Formatting Cell < Today() | Excel Worksheet Functions | |||
| HELP - Date Range In 1 Cell Calculation | Excel Worksheet Functions | |||
| i want to display the month from a date into another cell | Excel Worksheet Functions | |||
| Addition to Turn cell red if today is greater or equal to date in cell | New Users to Excel | |||
| GET.CELL | Excel Worksheet Functions | |||
Linear Mode
