Re: Excel 2007 numeric converted to date format

Hi Vern,
The excel workbook is one that I have maintained for a while.
It has some columns defined as dates and some as financial amounts.

A few months ago I converted from excel 2003 (.xls) to excel 2007 (.xlsx)
format.

Since then I have found that I can save the data after use and when I
re-open the file, sometimes the data is in the format that I saved it and
other times the entire workbook can have numeric data changed to date
format.
It's easy enough to reset, however, it should not require re-formatting.
I suspect you are correct about excel being over-helpful.


Norm Dennis

-----Original Message-----
From: pctech-bounces@xxxxxxxxxxxx [mailto:pctech-bounces@xxxxxxxxxxxx] On
Behalf Of Vern Hamberg
Sent: Sunday, 26 July 2009 11:36 PM
To: PC Technical Discussion for iSeries Users
Subject: Re: [PCTECH] Excel 2007 numeric converted to date format

Norm

Dates are stored as numbers, as you may know. The integer portion is the
number of days since 1/1/1900 or 1904 or some such - I forget. The
decimal portion is the time of day - noon is .5

So maybe Excel is being over-helpful, as it often is, IMO. Does is
display a date, or the original number? What are the numeric values when
this happens? You might need to change cell format to see the number.

Vern

Norm Dennis wrote:

Hi guys,

I have an issue with Excel 2007 which appears to be intermittent.



I have some spreadsheets inside a workbook which is a fairly simple list

of

transactions that get summarized into a set of totals.

The issue is that occasionally, when I open the spreadsheet the columns

have

been converted to a date format.



Has anyone heard of, seen, had this issue?



TIA,





Norm Dennis