Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date Time formatting problem
Hi all,
I am using Excel 2003 with Vista Business. International settings and date/time format set to United States. I am setting a "custom format" in a cell as dd mmm yy hh:mm. When the cell is empty the Type Function evaluates to 1 (numeric). I enter a date and time say 1/1/08 23:45 and this appears in the cell in exactly the same manner. The Type Function changes automatically and now evaluates to 2 as Text. If I enter a date without a time say 1/1/08 this appears as 1 Jan 08 00:00:00 (using same format as before dd mmm yy hh:mm). In the formula bar it appears as 01 01 2008 12:00:00 AM. I have workbooks developed in Excel 2000 with Windows XP which were working fine. Now with the same WkBks, but using Excel 2003, all of a sudden nothing with date/time in the same cell works. All formats have converted to Text. calculations cannot be performed. Am I missing something here which has changed between systems?? Thanks in advance/sgl |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date / Time problem | Excel Discussion (Misc queries) | |||
Having a problem formatting short time | New Users to Excel | |||
Time Formatting Problem | Excel Discussion (Misc queries) | |||
Problem with formatting time | Excel Discussion (Misc queries) | |||
Ugh..another time and date problem...HELP | Excel Worksheet Functions |