Re: Excel 2007 numeric converted to date format

Heh, agreed ;-)


Norm Dennis

-----Original Message-----
From: pctech-bounces@xxxxxxxxxxxx [mailto:pctech-bounces@xxxxxxxxxxxx] On
Behalf Of Dan
Sent: Tuesday, 28 July 2009 5:50 AM
To: PC Technical Discussion for iSeries Users
Subject: Re: [PCTECH] Excel 2007 numeric converted to date format

IMNSHO, it's not so much as Excel being "over-helpful" as it is that
Microsoft knows much better than you what the data is supposed to
represent. Don't like what Microsoft has decided it should be? Tough....
you know. Eventually you'll figure out how to override the "wisdom of
Redmond", but any notion of a user-intuitive application should be thrown
out the Window. (Pun not originally intended, but now that I see it... <g>)

Just my 2¢.
- Dan

On Mon, Jul 27, 2009 at 12:29 AM, Norm Dennis <nhdennis@xxxxxxxxxxx> wrote:

I have taken an old .xls file and converted it to .xlsx and it saves with
format "general".

I opened and saved the document a number of times without getting the

issue

of the format changing to date format.

My original document was worked with in the same way but I have noticed
that
the format of numeric defined columns have changed to date format on
occasions.

Just wondering if because the columns have multiple text headings, that

may

be causing the problem.
As Vern has mentioned, excel trying to be over-helpful.


Norm Dennis

-----Original Message-----
From: pctech-bounces@xxxxxxxxxxxx [mailto:pctech-bounces@xxxxxxxxxxxx] On
Behalf Of Jim Franz
Sent: Monday, 27 July 2009 12:29 AM
To: PC Technical Discussion for iSeries Users
Subject: Re: [PCTECH] Excel 2007 numeric converted to date format

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.

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