Hi Michael,
I don't know how much the other files will resemble that one or
exactly what you did to fix the one you have, but if they are the
same size pictures and formats you might be able to use the
recorded macro.

To record a macro Tools, Macro, record
but take a look at http://www.mvps.org/dmcritchie/excel/getstarted.htm

You start the macro recorder than you make your manual
changes to the Excel file. You stop the macro recorder when it
looks good.

Then you can try your macro (Macro1 if you never recorded one before)
on another file opened in Excel. You will find your macro with Alt+F8
when you want to run it.

My email address is on every posting, and "email comments" appears
at the bottom of all of my webpages.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"michaeltan" wrote in message
...

Thanks David,

I greatly appreciate your comments and assistance. I did convert it to
xls and after adjusting/deleting columns and rows, the excel version
looks good. I'm not familiar with macro; as I said I need to convert
similar html files to excel format ... for many of these data sheets.
And it will be very unproductive to adjust everyone of them.

Does a marco solves this problem ?

Do you have a email address which I can send my excel file (after
conversion and re-adjustment) ?

Yes, my intention to convert to excel is to enable me to make changes
to figures easily and I'm not converting it back to html.

Once again, thank you !


--
michaeltan
------------------------------------------------------------------------
michaeltan's Profile: http://www.excelforum.com/member.php...o&userid=25592
View this thread: http://www.excelforum.com/showthread...hreadid=390117