Microsoft KB Archive/171279: Difference between revisions
(importing KB archive) |
m (Text replacement - """ to """) |
||
Line 57: | Line 57: | ||
== CAUSE == | == CAUSE == | ||
This problem occurs if the HTML document contains any styles that use | This problem occurs if the HTML document contains any styles that use "[dquote]" or "[squote]," as in the following example: | ||
<pre class="codesample"> STYLE= | <pre class="codesample"> STYLE="vnd.ms-excel.numberformat:_($* #,##0_)[semicolon]_($* (#,##0) | ||
[semicolon]_($* [dquote]-[dquote]_)[semicolon]_(@_) | [semicolon]_($* [dquote]-[dquote]_)[semicolon]_(@_)" | ||
</pre> | </pre> | ||
Line 72: | Line 72: | ||
<pre class="fixed_text"> Replace With This Character | <pre class="fixed_text"> Replace With This Character | ||
----------------------------------- | ----------------------------------- | ||
[dquote] | [dquote] " | ||
[squote] ' | [squote] ' | ||
</pre> | </pre> | ||
Line 89: | Line 89: | ||
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: | 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: | ||
<pre class="codesample"> STYLE= | <pre class="codesample"> STYLE="vnd.ms-excel.numberformat:$#.0000[semicolon]($#.0000)" | ||
</pre> | </pre> | ||
In this case, the number format that Microsoft Excel applies to the value is the following: | In this case, the number format that Microsoft Excel applies to the value is the following: | ||
Line 100: | Line 100: | ||
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.<br /> | 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.<br /> | ||
<br /> | <br /> | ||
If the number format in Microsoft Excel contains quotation marks ( | 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. | ||
</div> | </div> |
Latest revision as of 11:05, 21 July 2020
Article ID: 171279
Article Last Modified on 10/22/2000
APPLIES TO
- Microsoft Excel 97 Standard Edition
This article was previously published under Q171279
SYMPTOMS
When you open a Hypertext Markup Language (HTML) document in Microsoft Excel 97, you may receive the following error message:
You receive this error message even if you saved the HTML document from Microsoft Excel 97 by clicking Save As HTML on the File menu.
CAUSE
This problem occurs if the HTML document contains any styles that use "[dquote]" or "[squote]," as in the following example:
STYLE="vnd.ms-excel.numberformat:_($* #,##0_)[semicolon]_($* (#,##0) [semicolon]_($* [dquote]-[dquote]_)[semicolon]_(@_)"
RESOLUTION
To correct this problem, install Microsoft Excel 97 Service Release 1 (SR-1) and open the file.
To work around this problem, replace the strings in the HTML file with the appropriate character as in the following table.
Replace With This Character ----------------------------------- [dquote] " [squote] '
STATUS
Microsoft has confirmed this to be a problem in Microsoft Excel 97. This problem was corrected in Microsoft Excel 97 SR-1.
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:
$#.0000;($#.0000)
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.
Additional query words: XL97 htm sr1
Keywords: kberrmsg kbbug kbfix kbweb KB171279