https://www.betaarchive.com/wiki/index.php?title=Microsoft_KB_Archive/103282&feed=atom&action=history
Microsoft KB Archive/103282 - Revision history
2024-03-29T07:30:26Z
Revision history for this page on the wiki
MediaWiki 1.39.3
https://www.betaarchive.com/wiki/index.php?title=Microsoft_KB_Archive/103282&diff=262249&oldid=prev
X010: Text replacement - """ to """
2020-07-20T08:25:58Z
<p>Text replacement - """ to """</p>
<table style="background-color: #fff; color: #202122;" data-mw="interface">
<col class="diff-marker" />
<col class="diff-content" />
<col class="diff-marker" />
<col class="diff-content" />
<tr class="diff-title" lang="en-GB">
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td>
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 08:25, 20 July 2020</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l31">Line 31:</td>
<td colspan="2" class="diff-lineno">Line 31:</td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>=== Microsoft Excel versions 4.0 and 4.0a for Windows ===</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>=== Microsoft Excel versions 4.0 and 4.0a for Windows ===</div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td></tr>
<tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>Equal Sign <del style="font-weight: bold; text-decoration: none;">&quot;</del>=<del style="font-weight: bold; text-decoration: none;">&quot; </del>Plus Sign <del style="font-weight: bold; text-decoration: none;">&quot;</del>+<del style="font-weight: bold; text-decoration: none;">&quot; </del>Minus Sign <del style="font-weight: bold; text-decoration: none;">&quot;</del>-<del style="font-weight: bold; text-decoration: none;">&quot; </del>Multiplication Sign <del style="font-weight: bold; text-decoration: none;">&quot;</del>*<del style="font-weight: bold; text-decoration: none;">&quot; </del>Division Sign <del style="font-weight: bold; text-decoration: none;">&quot;</del>/<del style="font-weight: bold; text-decoration: none;">&quot; </del>Exponentiation Sign <del style="font-weight: bold; text-decoration: none;">&quot;</del>^<del style="font-weight: bold; text-decoration: none;">&quot; </del>Left Parenthesis <del style="font-weight: bold; text-decoration: none;">&quot;</del>(<del style="font-weight: bold; text-decoration: none;">&quot; </del>Right Parenthesis <del style="font-weight: bold; text-decoration: none;">&quot;</del>)<del style="font-weight: bold; text-decoration: none;">&quot; </del>Comma <del style="font-weight: bold; text-decoration: none;">&quot;</del>,<del style="font-weight: bold; text-decoration: none;">&quot; </del>Percent Sign <del style="font-weight: bold; text-decoration: none;">&quot;</del>%<del style="font-weight: bold; text-decoration: none;">&quot; </del>Dollar Sign <del style="font-weight: bold; text-decoration: none;">&quot;</del>$<del style="font-weight: bold; text-decoration: none;">&quot; </del>Colon <del style="font-weight: bold; text-decoration: none;">&quot;</del>:<del style="font-weight: bold; text-decoration: none;">&quot;</del></div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>Equal Sign <ins style="font-weight: bold; text-decoration: none;">"</ins>=<ins style="font-weight: bold; text-decoration: none;">" </ins>Plus Sign <ins style="font-weight: bold; text-decoration: none;">"</ins>+<ins style="font-weight: bold; text-decoration: none;">" </ins>Minus Sign <ins style="font-weight: bold; text-decoration: none;">"</ins>-<ins style="font-weight: bold; text-decoration: none;">" </ins>Multiplication Sign <ins style="font-weight: bold; text-decoration: none;">"</ins>*<ins style="font-weight: bold; text-decoration: none;">" </ins>Division Sign <ins style="font-weight: bold; text-decoration: none;">"</ins>/<ins style="font-weight: bold; text-decoration: none;">" </ins>Exponentiation Sign <ins style="font-weight: bold; text-decoration: none;">"</ins>^<ins style="font-weight: bold; text-decoration: none;">" </ins>Left Parenthesis <ins style="font-weight: bold; text-decoration: none;">"</ins>(<ins style="font-weight: bold; text-decoration: none;">" </ins>Right Parenthesis <ins style="font-weight: bold; text-decoration: none;">"</ins>)<ins style="font-weight: bold; text-decoration: none;">" </ins>Comma <ins style="font-weight: bold; text-decoration: none;">"</ins>,<ins style="font-weight: bold; text-decoration: none;">" </ins>Percent Sign <ins style="font-weight: bold; text-decoration: none;">"</ins>%<ins style="font-weight: bold; text-decoration: none;">" </ins>Dollar Sign <ins style="font-weight: bold; text-decoration: none;">"</ins>$<ins style="font-weight: bold; text-decoration: none;">" </ins>Colon <ins style="font-weight: bold; text-decoration: none;">"</ins>:<ins style="font-weight: bold; text-decoration: none;">"</ins></div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>=== Microsoft Excel for version 4.0 the Macintosh ===</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>=== Microsoft Excel for version 4.0 the Macintosh ===</div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td></tr>
<tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>Equal Sign <del style="font-weight: bold; text-decoration: none;">&quot;</del>=<del style="font-weight: bold; text-decoration: none;">&quot; </del>Plus Sign <del style="font-weight: bold; text-decoration: none;">&quot;</del>+<del style="font-weight: bold; text-decoration: none;">&quot; </del>Minus Sign <del style="font-weight: bold; text-decoration: none;">&quot;</del>-<del style="font-weight: bold; text-decoration: none;">&quot; </del>Multiplication Sign <del style="font-weight: bold; text-decoration: none;">&quot;</del>*<del style="font-weight: bold; text-decoration: none;">&quot; </del>Division Sign <del style="font-weight: bold; text-decoration: none;">&quot;</del>/<del style="font-weight: bold; text-decoration: none;">&quot; </del>Exponentiation Sign <del style="font-weight: bold; text-decoration: none;">&quot;</del>^<del style="font-weight: bold; text-decoration: none;">&quot; </del>Left Parenthesis <del style="font-weight: bold; text-decoration: none;">&quot;</del>(<del style="font-weight: bold; text-decoration: none;">&quot; </del>Right Parenthesis <del style="font-weight: bold; text-decoration: none;">&quot;</del>)<del style="font-weight: bold; text-decoration: none;">&quot; </del>Comma <del style="font-weight: bold; text-decoration: none;">&quot;</del>,<del style="font-weight: bold; text-decoration: none;">&quot; </del>Percent Sign <del style="font-weight: bold; text-decoration: none;">&quot;</del>%<del style="font-weight: bold; text-decoration: none;">&quot;</del></div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>Equal Sign <ins style="font-weight: bold; text-decoration: none;">"</ins>=<ins style="font-weight: bold; text-decoration: none;">" </ins>Plus Sign <ins style="font-weight: bold; text-decoration: none;">"</ins>+<ins style="font-weight: bold; text-decoration: none;">" </ins>Minus Sign <ins style="font-weight: bold; text-decoration: none;">"</ins>-<ins style="font-weight: bold; text-decoration: none;">" </ins>Multiplication Sign <ins style="font-weight: bold; text-decoration: none;">"</ins>*<ins style="font-weight: bold; text-decoration: none;">" </ins>Division Sign <ins style="font-weight: bold; text-decoration: none;">"</ins>/<ins style="font-weight: bold; text-decoration: none;">" </ins>Exponentiation Sign <ins style="font-weight: bold; text-decoration: none;">"</ins>^<ins style="font-weight: bold; text-decoration: none;">" </ins>Left Parenthesis <ins style="font-weight: bold; text-decoration: none;">"</ins>(<ins style="font-weight: bold; text-decoration: none;">" </ins>Right Parenthesis <ins style="font-weight: bold; text-decoration: none;">"</ins>)<ins style="font-weight: bold; text-decoration: none;">" </ins>Comma <ins style="font-weight: bold; text-decoration: none;">"</ins>,<ins style="font-weight: bold; text-decoration: none;">" </ins>Percent Sign <ins style="font-weight: bold; text-decoration: none;">"</ins>%<ins style="font-weight: bold; text-decoration: none;">"</ins></div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td></tr>
<tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>NOTE: The Dollar Sign (<del style="font-weight: bold; text-decoration: none;">&quot;</del>$<del style="font-weight: bold; text-decoration: none;">&quot;</del>) tool and the Colon (<del style="font-weight: bold; text-decoration: none;">&quot;</del>:<del style="font-weight: bold; text-decoration: none;">&quot;</del>) tool only display this behavior in the Windows version.</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>NOTE: The Dollar Sign (<ins style="font-weight: bold; text-decoration: none;">"</ins>$<ins style="font-weight: bold; text-decoration: none;">"</ins>) tool and the Colon (<ins style="font-weight: bold; text-decoration: none;">"</ins>:<ins style="font-weight: bold; text-decoration: none;">"</ins>) tool only display this behavior in the Windows version.</div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>== STATUS ==</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>== STATUS ==</div></td></tr>
<tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l45">Line 45:</td>
<td colspan="2" class="diff-lineno">Line 45:</td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>== MORE INFORMATION ==</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>== MORE INFORMATION ==</div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td></tr>
<tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>You can use custom formula tools when you create formulas. For example, if you want to enter the formula =10+10, you can use the Equal Sign (<del style="font-weight: bold; text-decoration: none;">&quot;</del>=<del style="font-weight: bold; text-decoration: none;">&quot;</del>) and Plus Sign (<del style="font-weight: bold; text-decoration: none;">&quot;</del>+<del style="font-weight: bold; text-decoration: none;">&quot;</del>) tools to create the formula instead of typing these characters on the keyboard.</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>You can use custom formula tools when you create formulas. For example, if you want to enter the formula =10+10, you can use the Equal Sign (<ins style="font-weight: bold; text-decoration: none;">"</ins>=<ins style="font-weight: bold; text-decoration: none;">"</ins>) and Plus Sign (<ins style="font-weight: bold; text-decoration: none;">"</ins>+<ins style="font-weight: bold; text-decoration: none;">"</ins>) tools to create the formula instead of typing these characters on the keyboard.</div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>To use the custom tools in the Formula category in the Customize dialog box:</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>To use the custom tools in the Formula category in the Customize dialog box:</div></td></tr>
<tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l55">Line 55:</td>
<td colspan="2" class="diff-lineno">Line 55:</td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>== REFERENCES ==</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>== REFERENCES ==</div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td></tr>
<tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del style="font-weight: bold; text-decoration: none;">&quot;</del>User's Guide 2,<del style="font-weight: bold; text-decoration: none;">&quot; </del>version 4.0, pages 178-179</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">"</ins>User's Guide 2,<ins style="font-weight: bold; text-decoration: none;">" </ins>version 4.0, pages 178-179</div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>{|</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>{|</div></td></tr>
<tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l70">Line 70:</td>
<td colspan="2" class="diff-lineno">Line 70:</td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div><br /></div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div><br /></div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div><br /></div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div><br /></div></td></tr>
<tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED <del style="font-weight: bold; text-decoration: none;">&quot;</del>AS IS<del style="font-weight: bold; text-decoration: none;">&quot; </del>WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED <ins style="font-weight: bold; text-decoration: none;">"</ins>AS IS<ins style="font-weight: bold; text-decoration: none;">" </ins>WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.</div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div></blockquote></div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div></blockquote></div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div><span>Last reviewed: September 12, 1996</span><br /></div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div><span>Last reviewed: September 12, 1996</span><br /></div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>[[../cpyright|©1997 Microsoft Corporation. All rights reserved. Legal Notices]].<br /></div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>[[../cpyright|©1997 Microsoft Corporation. All rights reserved. Legal Notices]].<br /></div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>|}</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>|}</div></td></tr>
</table>
X010
https://www.betaarchive.com/wiki/index.php?title=Microsoft_KB_Archive/103282&diff=47647&oldid=prev
3155ffGd: importing KB archive
2020-07-18T15:03:09Z
<p>importing KB archive</p>
<p><b>New page</b></p><div>= Microsoft Knowledge Base =<br />
<br />
== Excel: Custom Formula Tools Don't Work on Protected Document ==<br />
<br />
<span>Last reviewed: September 12, 1996<br /><br />
Article ID: Q103282</span><br />
<br />
The information in this article applies to:<br />
<br />
* Microsoft Excel for Windows, versions 4.0, 4.0a<br />
* Microsoft Excel for the Macintosh, version 4.0<br />
<br />
== SYMPTOMS ==<br />
<br />
In Microsoft Excel, when you are using a protected document, you may receive an error message when you attempt to use some of the custom tools from the Formula category of the Customize dialog box (even if the cells they are being used on are not locked).<br />
<br />
== CAUSE ==<br />
<br />
In most cases, when you try to use these custom formula tools you will receive the following error message:<br />
<br />
<pre> Cannot use that command on a protected document<br />
</pre><br />
However, when you use some of these tools, you will receive the error message<br />
<br />
<pre> Locked cells cannot be changed<br />
</pre><br />
even though the cells that the tools are being used on are unlocked.<br />
<br />
This problem occurs with the following formula tools.<br />
<br />
=== Microsoft Excel versions 4.0 and 4.0a for Windows ===<br />
<br />
Equal Sign &quot;=&quot; Plus Sign &quot;+&quot; Minus Sign &quot;-&quot; Multiplication Sign &quot;*&quot; Division Sign &quot;/&quot; Exponentiation Sign &quot;^&quot; Left Parenthesis &quot;(&quot; Right Parenthesis &quot;)&quot; Comma &quot;,&quot; Percent Sign &quot;%&quot; Dollar Sign &quot;$&quot; Colon &quot;:&quot;<br />
<br />
=== Microsoft Excel for version 4.0 the Macintosh ===<br />
<br />
Equal Sign &quot;=&quot; Plus Sign &quot;+&quot; Minus Sign &quot;-&quot; Multiplication Sign &quot;*&quot; Division Sign &quot;/&quot; Exponentiation Sign &quot;^&quot; Left Parenthesis &quot;(&quot; Right Parenthesis &quot;)&quot; Comma &quot;,&quot; Percent Sign &quot;%&quot;<br />
<br />
NOTE: The Dollar Sign (&quot;$&quot;) tool and the Colon (&quot;:&quot;) tool only display this behavior in the Windows version.<br />
<br />
== STATUS ==<br />
<br />
Microsoft has confirmed this to be a problem in the versions of Microsoft Excel listed above. This problem does not occur in later versions.<br />
<br />
== MORE INFORMATION ==<br />
<br />
You can use custom formula tools when you create formulas. For example, if you want to enter the formula =10+10, you can use the Equal Sign (&quot;=&quot;) and Plus Sign (&quot;+&quot;) tools to create the formula instead of typing these characters on the keyboard.<br />
<br />
To use the custom tools in the Formula category in the Customize dialog box:<br />
<br />
# From the Options menu, Choose Toolbars.<br />
# Choose the Customize button.<br />
# Under Categories, select Formula and follow the instructions in the Customize dialog box.<br />
<br />
== REFERENCES ==<br />
<br />
&quot;User's Guide 2,&quot; version 4.0, pages 178-179<br />
<br />
{|<br />
|width="100%"|<br />
<br />
-----<br />
<br />
<blockquote><span style="font-family:verdana,arial,helvetica; font-size:8pt"> KBCategory: kbinterop<br /><br />
KBSubcategory: </span><br />
<br />
Additional reference words: 4.00 4.00a protection customized command<br /><br />
macro<br />
<br />
<br /><br />
<br /><br />
THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED &quot;AS IS&quot; WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.<br />
</blockquote><br />
<span>Last reviewed: September 12, 1996</span><br /><br />
[[../cpyright|©1997 Microsoft Corporation. All rights reserved. Legal Notices]].<br /><br />
|}</div>
3155ffGd