https://www.betaarchive.com/wiki/index.php?title=Microsoft_KB_Archive/248007&feed=atom&action=history
Microsoft KB Archive/248007 - Revision history
2024-03-28T23:24:54Z
Revision history for this page on the wiki
MediaWiki 1.39.3
https://www.betaarchive.com/wiki/index.php?title=Microsoft_KB_Archive/248007&diff=376141&oldid=prev
X010: Text replacement - """ to """
2020-07-21T12:50:35Z
<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 12:50, 21 July 2020</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l57">Line 57:</td>
<td colspan="2" class="diff-lineno">Line 57:</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>The behavior occurs when the following conditions are true:</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>The behavior occurs when the following conditions are true:</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># You set the '''Short date style''' regional setting in Control Panel to a two-digit year format (for example, <del style="font-weight: bold; text-decoration: none;">&quot;</del>M/d/yy<del style="font-weight: bold; text-decoration: none;">&quot;</del>), so that a date is automatically displayed with a two-digit year.</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 set the '''Short date style''' regional setting in Control Panel to a two-digit year format (for example, <ins style="font-weight: bold; text-decoration: none;">"</ins>M/d/yy<ins style="font-weight: bold; text-decoration: none;">"</ins>), so that a date is automatically displayed with a two-digit year.</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># You type dates in a workbook including the day, month and year, using the dash (-) or slash mark (/) separators in one or more cells.</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># You type dates in a workbook including the day, month and year, using the dash (-) or slash mark (/) separators in one or more cells.</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># You do not click '''Cells''' on the '''Format''' menu to change the number format. You leave the date formatted as the default number format.</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># You do not click '''Cells''' on the '''Format''' menu to change the number format. You leave the date formatted as the default number format.</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># You adjust the column width just wide enough to display the date in the cell.</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># You adjust the column width just wide enough to display the date in the cell.</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># You close the workbook.</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># You close the workbook.</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># You set the '''Short date style''' regional setting in Control Panel to a four-digit year format (for example, <del style="font-weight: bold; text-decoration: none;">&quot;</del>M/d/yyyy<del style="font-weight: bold; text-decoration: none;">&quot;</del>), so that a date is automatically displayed with a four-digit year.</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 set the '''Short date style''' regional setting in Control Panel to a four-digit year format (for example, <ins style="font-weight: bold; text-decoration: none;">"</ins>M/d/yyyy<ins style="font-weight: bold; text-decoration: none;">"</ins>), so that a date is automatically displayed with a four-digit year.</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># You reopen the workbook.</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># You reopen the workbook.</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 colspan="2" class="diff-lineno" id="mw-diff-left-l80">Line 80:</td>
<td colspan="2" class="diff-lineno">Line 80:</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>Microsoft Excel uses the '''Regional Options''' or '''Regional Settings''' icon in Control Panel to determine what number formats to use and the correct separators to use (for example <del style="font-weight: bold; text-decoration: none;">&quot;</del>/<del style="font-weight: bold; text-decoration: none;">&quot; </del>or <del style="font-weight: bold; text-decoration: none;">&quot;</del>-<del style="font-weight: bold; text-decoration: none;">&quot;</del>). These settings affect the way Microsoft Excel displays and uses dates, times, currencies, and numbers. If you type a date in a cell and do not click '''Cells''' on the '''Format''' menu to choose a number format, Excel defaults to the '''Short date style''' in Control Panel. When the '''Short date style''' setting changes, the date format automatically changes in the cells in Excel.</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>Microsoft Excel uses the '''Regional Options''' or '''Regional Settings''' icon in Control Panel to determine what number formats to use and the correct separators to use (for example <ins style="font-weight: bold; text-decoration: none;">"</ins>/<ins style="font-weight: bold; text-decoration: none;">" </ins>or <ins style="font-weight: bold; text-decoration: none;">"</ins>-<ins style="font-weight: bold; text-decoration: none;">"</ins>). These settings affect the way Microsoft Excel displays and uses dates, times, currencies, and numbers. If you type a date in a cell and do not click '''Cells''' on the '''Format''' menu to choose a number format, Excel defaults to the '''Short date style''' in Control Panel. When the '''Short date style''' setting changes, the date format automatically changes in the cells in Excel.</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></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></div></td></tr>
</table>
X010
https://www.betaarchive.com/wiki/index.php?title=Microsoft_KB_Archive/248007&diff=136396&oldid=prev
3155ffGd: importing KB archive
2020-07-18T16:13:56Z
<p>importing KB archive</p>
<p><b>New page</b></p><div><div id="nsbanner"><br />
<br />
<div id="bannerrow1"><br />
<br />
{|<br />
| Knowledge Base<br />
|<br />
|}<br />
<br />
<br />
</div><br />
<div id="TitleRow"><br />
<br />
= <span id="KB248007"></span>XL2000: Number Signs (###) Displayed in Cells of a Worksheet That Contain Dates =<br />
<br />
<br />
</div><br />
<br />
</div><br />
<div id="nstext" valign="BOTTOM"><br />
<br />
Article ID: 248007<br />
<br />
Article Last Modified on 9/25/2003<br />
<br />
<br />
-----<br />
<br />
APPLIES TO<br /><br />
<br /><br />
<br />
* Microsoft Excel 2000 Standard Edition<br />
<br />
<br />
-----<br />
<br />
<div class="notice_section"><br />
<br />
This article was previously published under Q248007<br />
<br />
</div><br />
<div class="notice_section"><br />
<br />
<br />
<br />
</div><br />
<div class="symptoms_section"><br />
<br />
== SYMPTOMS ==<br />
<br />
When you open an existing worksheet, you see number signs (###) in cells that contain dates.<br />
<br />
</div><br />
<div class="cause_section"><br />
<br />
== CAUSE ==<br />
<br />
The behavior occurs when the following conditions are true:<br />
# You set the '''Short date style''' regional setting in Control Panel to a two-digit year format (for example, &quot;M/d/yy&quot;), so that a date is automatically displayed with a two-digit year.<br />
# You type dates in a workbook including the day, month and year, using the dash (-) or slash mark (/) separators in one or more cells.<br />
# You do not click '''Cells''' on the '''Format''' menu to change the number format. You leave the date formatted as the default number format.<br />
# You adjust the column width just wide enough to display the date in the cell.<br />
# You close the workbook.<br />
# You set the '''Short date style''' regional setting in Control Panel to a four-digit year format (for example, &quot;M/d/yyyy&quot;), so that a date is automatically displayed with a four-digit year.<br />
# You reopen the workbook.<br />
<br />
<br />
</div><br />
<div class="workaround_section"><br />
<br />
== WORKAROUND ==<br />
<br />
With the cell selected, point to '''Column''' on the '''Format''' menu and click '''AutoFit Selection''' to widen the column to display the newly formatted dates.<br /><br />
<br /><br />
'''NOTE''': After you widen the columns, worksheets may be printed differently. Check your print settings after the changes.<br />
<br />
</div><br />
<div class="moreinformation_section"><br />
<br />
== MORE INFORMATION ==<br />
<br />
Microsoft Excel uses the '''Regional Options''' or '''Regional Settings''' icon in Control Panel to determine what number formats to use and the correct separators to use (for example &quot;/&quot; or &quot;-&quot;). These settings affect the way Microsoft Excel displays and uses dates, times, currencies, and numbers. If you type a date in a cell and do not click '''Cells''' on the '''Format''' menu to choose a number format, Excel defaults to the '''Short date style''' in Control Panel. When the '''Short date style''' setting changes, the date format automatically changes in the cells in Excel.<br />
<br />
</div><br />
<div class="references_section"><br />
<br />
== REFERENCES ==<br />
<br />
For additional information about how Microsoft Excel works with two-digit year numbers, click the article number below to view the article in the Microsoft Knowledge Base:<br />
<div class="indent"><br />
<br />
[[../214391|214391]] XL2000: How Microsoft Excel Works with Two-Digit Year Numbers<br />
<br />
<br />
</div><br />
<br />
</div><br />
<br /><br />
<br />
Additional query words: XL2000 y2k pound key<br />
<br />
Keywords: kbprb KB248007<br />
<br />
<div class="footer"><br />
<br />
<br /><br />
<br />
<br />
-----<br />
<br />
[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]<br />
<br />
<span>© Microsoft Corporation. All rights reserved.</span><br />
<br />
<br />
</div><br />
<br />
</div></div>
3155ffGd