Microsoft KB Archive/214307

= XL2000: Financial or Accounting AutoFormats Change Number Formats =

Article ID: 214307

Article Last Modified on 11/5/2003

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition

-



This article was previously published under Q214307





SUMMARY
In Microsoft Excel 2000, the AutoFormat command will not change the number format of selected cells unless you choose an Accounting built-in format.



MORE INFORMATION
While most of the built-in formats change attributes such as cell shading, borders, and fonts, some built-in formats change the number format. The built-in formats that change number formats are the four accounting formats.

The AutoFormat tool in Microsoft Excel provides a fast and efficient way to apply built-in formats. Using AutoFormat can make your worksheet more readable and more professional looking by changing the alignments, borders, fonts, patterns, and shading of selected cells.

Keywords: kbhowto KB214307

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.