XL2000: Financial or Accounting AutoFormats Change Number Formats (214307)
The information in this article applies to:
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.
| Modification Type: | Major | Last Reviewed: | 11/5/2003 |
|---|
| Keywords: | kbhowto KB214307 |
|---|
|