Re: how to convert a html page to excel format ?

HI Michael,
Please explain messed up. I opened the file in Excel 2000 (file, open) as Jon
suggested and it it looks fine in Excel. In fact if you will notice in the
HTML there are rows that do not line up, yet Excel lined those rows
up -- like the stuff under "Packing Specifications" does not originally
line up with content to the left and I was very much surprised that
something that looks independently formatted would appear on
same rows.

You could make some changes like the following, you probably won't
like the results as far as readability goes because of the merged cells.

format, cells, alignment, vertical: top (Excel defaults to bottom)

select numeric cells -- Ctrl+A, Edit, go to (Ctr+G), Special, Constants + Numbers
then on the Excel toolbars click on the Centered format to unselect it.

select numeric cells -- Ctrl+A, Edit, go to (Ctr+G), Special, Constants + Text
then on the Excel toolbars click on the Centered format to unselect it.

Because of merged cells you find some of your numbers way far to the
right


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" <michaeltan.1sxbmj_1122627929.9152@xxxxxxxxxxxxxxxxxxxxx> wrote in message
news:michaeltan.1sxbmj_1122627929.9152@xxxxxxxxxxxxxxxxxxxxxxxx
>
> No, I have not get the problem resolved. I certainly would appreciate if
> you can help to convert existing html to excel.
> http://147.202.45.242/~calscan/intranet/print.php?LID=33


.

Relevant Pages

  • Re: Problem with selecting a column in a macro
    ... I don't think you can specify this. ... It seems each version of excel treats merged cells differently. ... Excel VBA reference at msdn, thinking there might be some parameters I ...
    (microsoft.public.excel.programming)
  • Re: Slow performance in Excel
    ... have you starts by unselect all items and than select only the one you need ... then start excel and see what's appends from the very beginning. ... the cube. ... > a new pivot table using the same foramt, layout and setting, the speed ...
    (microsoft.public.sqlserver.olap)
  • Embeddign MS Word into Excel
    ... Eliminate the merged cells - this is not currently an option. ... any EXCEL cells below it, thus hiding critical informaiton. ... I'm effectively using EXCEL for a request form where each work ...
    (microsoft.public.excel)
  • Re: Cant Wrap text in the Merge Cells
    ... The WrapText property of the merged cells has to be set to True. ... Dim cWdth As Single, MrgeWdth As Single ... Gord Dibben MS Excel MVP ...
    (microsoft.public.excel.misc)
  • Re: Cant Wrap text in the Merge Cells
    ... The WrapText property of the merged cells has to be set to True. ... Dim cWdth As Single, MrgeWdth As Single ... Gord Dibben MS Excel MVP ...
    (microsoft.public.excel.misc)