Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Help,
I have a date / time cell where I am using a custom format and there are two other date fields that calculate based in its value. I can enter any legitimate date and it will all format and calculate correctly (so far as I have tried) except for "11/2/2009 6:00:00 AM" The custom format is "ddd m/d h:mm AM/PM". The time does not seem to matter so long as the date is 11/2/2009. Other dates and years work fine. For that date, the display field is all hashmarks and only one of the calculated fields is all hasmarks. If you do a holdover, the right values are shown in the little popup. I have office 2007 and it is supposed to be updated automatically running on XP (also updated). (Where did about go?) Confounding. Any suggestions appreciated, Thanks, Steve |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel Format Problem - Date Overrides Format | Excel Discussion (Misc queries) | |||
date format problem?? | Excel Discussion (Misc queries) | |||
Date format problem | Excel Worksheet Functions | |||
Date Format Problem | Excel Discussion (Misc queries) | |||
date format problem | Excel Discussion (Misc queries) |