XL97: Number Formats Lost Error Opening HTML File

   STYLE="vnd.ms-excel.numberformat:_($* #,##0_)[semicolon]_($* (#,##0)
   [semicolon]_($* [dquote]-[dquote]_)[semicolon]_(@_)"
				

   Replace         With This Character
   -----------------------------------
   [dquote]                  "
   [squote]                  '
				

MORE INFORMATION

When you create an HTML file that may be opened in Microsoft Excel 97, you can force Microsoft Excel 97 to apply specific number formats to values in the HTML file by using a STYLE tag. The following is an example of a STYLE tag:

   STYLE="vnd.ms-excel.numberformat:$#.0000[semicolon]($#.0000)"
				

In this case, the number format that Microsoft Excel applies to the value is the following: When you open an HTML file that contains such a tag, Microsoft Excel 97 automatically applies the format to the value to which the tag is attached.

If the number format in Microsoft Excel contains quotation marks (") or apostrophes ('), and if you export a worksheet to an HTML file by clicking Save As HTML on the File menu, the tag in the HTML file contains [dquote] or [squote] instead of the quotation mark or apostrophe characters.