ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Centered Text Not Working in saved htm (https://www.excelbanter.com/excel-programming/326882-centered-text-not-working-saved-htm.html)

Wayne Wengert

Centered Text Not Working in saved htm
 
I have an Excel 2003 worksheet which includes some text centered across 6
columns. When I do a SaveAs and save it as HTM it looks fine in Excel but
when I load it to a web site it is left aligned?

Wayne



Patrick Molloy[_2_]

Centered Text Not Working in saved htm
 
you'll need to enclose quote marks around spaces as spaces are ignored in
HTML otherwise
eg
test
comes up as
test
while
' test'
will be
test

I think...

"Wayne Wengert" wrote:

I have an Excel 2003 worksheet which includes some text centered across 6
columns. When I do a SaveAs and save it as HTM it looks fine in Excel but
when I load it to a web site it is left aligned?

Wayne




Wayne Wengert

Centered Text Not Working in saved htm
 
It turns out that I had a graphic in the cell along with the text. Excel
handled it OK, even when I did a SaveAs htm format but the resulting htm
page would not render correctly. I moved the graphic to its own cell,
outside of those being centered, and it works.

I guess it is the way Excel writes the html code when it has a graphic in
the mix?

Wayne

"Wayne Wengert" wrote in message
...
I have an Excel 2003 worksheet which includes some text centered across 6
columns. When I do a SaveAs and save it as HTM it looks fine in Excel but
when I load it to a web site it is left aligned?

Wayne






All times are GMT +1. The time now is 03:36 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com