Microsoft KB Archive/119258

= Microsoft Knowledge Base =

XL: AutoFormat Does Not Apply Currency Format to All Rows
Last reviewed: March 27, 1997

Article ID: Q119258

4.00 4.00a 5.00 5.00c 7.00 | 4.00 5.00

WINDOWS                   | MACINTOSH kbother

The information in this article applies to:


 * Microsoft Excel for Windows, versions 4.0, 4.0a, 5.0, 5.0c
 * Microsoft Excel for Windows 95, version 7.0
 * Microsoft Excel for the Macintosh, versions 4.0, 5.0

SYMPTOMS
In Microsoft Excel, when you apply one of the Accounting (versions 5.x and 7.0) or Finance (version 4.0) formats using the AutoFormat feature, the currency number format ($) is applied only to the first row and the Total row in the data range.

CAUSE
This behavior is by design in Microsoft Excel. There is no documentation that states that an Accounting or Financial format must have a currency format applied to all of the cells.

WORKAROUND
To work around this behavior, you must apply the desired currency format to all of the cells that do not have this format applied by the AutoFormat feature.

Note that when you apply one of the Accounting autoformats in Microsoft Excel version 5.x or 7.0, the following Accounting category format code is applied:

_($* #,##0.00_);_($* (#,##0.00);_($* "-"??_);_(@_) When you apply one of the Finance autoformats in Microsoft Excel version 4.0, the following Currency category format code is applied:

$#,##0.00_);[Red]($#,##0.00)