XL2000: Financial or Accounting AutoFormats Change Number Formats

• Microsoft Excel 2000

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.

Additional query words:

Keywords : xlformula
Version : WINDOWS:2000
Platform : WINDOWS
Issue type : kbhowto