LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default Date Format Problem (bug)

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel Format Problem - Date Overrides Format Mary Excel Discussion (Misc queries) 5 February 10th 10 05:49 AM
date format problem?? Steve[_9_] Excel Discussion (Misc queries) 10 December 27th 07 11:23 PM
Date format problem Natalie Excel Worksheet Functions 4 June 7th 07 01:28 PM
Date Format Problem Gayla Excel Discussion (Misc queries) 3 April 18th 07 07:48 PM
date format problem Nigel Excel Discussion (Misc queries) 7 May 11th 05 12:57 PM


All times are GMT +1. The time now is 04:44 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"