C
colo_artist
Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel I searched the forum, but couldn't find any answers to this...
I was getting odd text headers in Excel 2008 in some files brought from a Windows machine running Excel 2007.
The numbers looked familiar and then I recognized they were the HTML code for colors.
As best I can tell, Excel 2007 for Windows can have colored text in headers and footers, but Excel 2008 for the Mac cannot. When a file with colored text in the header is opened in Excel 2008, the HTML code for the color is shown as part of the text.
I tried changing the text to black in the 2007 file, but it just puts six zeros, 000000...the code for black, in the header when opened in Excel 2008.
Any ideas how I can set the colors back in the Windows Excel 2007 files so the headers won't be messed up in the 2008 Mac files?
Thanks.
I was getting odd text headers in Excel 2008 in some files brought from a Windows machine running Excel 2007.
The numbers looked familiar and then I recognized they were the HTML code for colors.
As best I can tell, Excel 2007 for Windows can have colored text in headers and footers, but Excel 2008 for the Mac cannot. When a file with colored text in the header is opened in Excel 2008, the HTML code for the color is shown as part of the text.
I tried changing the text to black in the 2007 file, but it just puts six zeros, 000000...the code for black, in the header when opened in Excel 2008.
Any ideas how I can set the colors back in the Windows Excel 2007 files so the headers won't be messed up in the 2008 Mac files?
Thanks.