Re: Excel 2007 numeric converted to date format

["Norm Dennis" <nhdennis@xxxxxxxxxxx>]

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
>
>
>
>  
>
>