Re: Excel 2007 numeric converted to date format

[Vern Hamberg <vhamberg@xxxxxxxxxxx>]

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