Date Time formatting problem
No this is a straight .xls file. I have opened an old xls workbook where a
template had been developed in Excel 2000 and tried to enter data in the
date/time formatted cells and this problem came to light.
Everything was converting to text either when I enetered data in blank new
cells or altering already completed cells.
I then tested this in a brand new workbook formatting new cells as I have
explained and the same thing happened.
Totally confused I am!!!!
"joel" wrote:
Did you save the file as CSV? CSF doesn't support formating or formulas. A
CSV file is really a text file that you can view with a text ditor like
notepad.
"sgl" wrote:
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
|