In Microsoft Excel 2000, the AutoFormat command will not change the number format of selected cells unless you choose an Accounting built-in format.
↑ Back to the top
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.
↑ Back to the top