Re: Excel 2007 numeric converted to date format

["Jim Franz" <franz400@xxxxxxxxxxxx>]

see if in the conversion the format changed to "General".
That's ms-speak for let us guess the format.
Jim
----- Original Message ----- 
From: "Norm Dennis" <nhdennis@xxxxxxxxxxx>
To: "'PC Technical Discussion for iSeries Users'" <pctech@xxxxxxxxxxxx>
Sent: Sunday, July 26, 2009 12:25 PM
Subject: Re: [PCTECH] 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
> --
> This is the PC Technical Discussion for iSeries Users (PcTech) mailing 
> list
> To post a message email: PcTech@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/pctech
> or email: PcTech-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/pctech.
>
> --
> This is the PC Technical Discussion for iSeries Users (PcTech) mailing 
> list
> To post a message email: PcTech@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/pctech
> or email: PcTech-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/pctech.