How do I work with Excel 2007 and htm files?

[Guest]

I created a htm file in Excel 97-2003 and I was able to access my tables and
change the information around. When I open the file in the new Excel 2007, it
changes a lot of my numbers to dates and some other crazy numbers I have no
idea where they come from.

I've tried going to excel options and turning off automatic calculations but
that doesn't help.

How do I get excel to not change any of the information in the cells of my
workbook? [In the previous excel all you had to do was insert an apostrophe '
to prevent any changes.]

Example:

Supposed to say: 01-05
Says: 39087

Supposed to say: 01-13
Says: 13-Jan


How do I keep excel from creating the _files folder when I create a htm file?
(I only want a simple htm file.)

Thanks!

 

[David McRitchie]

Perhaps you would be better off writing your own conversion
from Excel to HTML, see
http://www.mvps.org/dmcritchie/excel/xl2html.htm

and just maintain the Excel file, don't try to bring the HTML
file back to Excel to modify it. Dates and time are stored
as days after Jan 31, 1899 but incorrectly, and time is
a fraction of day. You would be better off formatting
each of your columns as you want it. Excel will guess at
whether something is a date and how it is formatted.

The _files folder includes or provides for a lot of things that you
probably don't have (otherwise it wouldn't be a simple HTML file).
So by using the macros on the xl2html.htm page you will be
creating the source yourself. As written it was designed to create
a table and to extract the table from the generated code and paste
it into your own HTML file, but you can modify the the code
generated before the table to be anything you want.