You are currently offline, waiting for your internet to reconnect

Currency Style Toolbar Button Applies Accounting Number Format

This article was previously published under Q151442
Retired KB Content Disclaimer
This article was written about products for which Microsoft no longer offers support. Therefore, this article is offered "as is" and will no longer be updated.
SYMPTOMS
When you click the Currency Style toolbar button, the first Accountingnumber format is applied to the cell. This behavior is not as expected;you may expect the Currency number format to be applied to the cell.
CAUSE
When you click the Currency Style toolbar button, the predefined cellstyle called Currency is applied to the cell. By default, the Currencystyle has only the Accounting number format defined. Therefore, when youclick the Currency Style toolbar button, this number format is applied tothe cell.
WORKAROUND
If you want to change the number format that is applied to the cell whenyou click the Currency Style toolbar button, you must change theformatting options set for the Currency style. For example, to have theCurrency Style toolbar button apply the Currency number format$#,##0.00_);($#,##0.00) follow these steps:
  1. On the Format menu, click Style.
  2. In the Style Name list, click Currency.
  3. Click Modify.
  4. On the Number tab of the Format Cells dialog box, click Currency in the Category list, and then click OK.
  5. Click OK.
When you click the Currency Style toolbar button, the first numberformat of the Currency category will be applied to the cell.
MORE INFORMATION
By default, both the Currency Style and Comma Style toolbar buttons applyaccounting number formats. For example, if you enter the number 1234.56into an unformatted cell, and then widen the column so that it is muchwider than necessary to fit this number, you will get results similar tothe following (based upon the toolbar button that you click).
   Toolbar button          Result   ------------------------------------   Currency Style          $   1,234.56   Comma Style                 1,234.56				
Note that the accounting number format applied by both of these toolbarbuttons will pad the cell with enough spaces to fill the column width.These spaces will not be readily seen under most circumstances, especiallywith the accounting number format applied by the Comma Style. But, if youapply an underline to the cell, the underline will run the full width ofthe column, even though the number you have may only go part of the wayacross the cell. Therefore, if you apply a single underline to the cellsin the above table, your results will be similar to the following.
   Toolbar button          Result   ------------------------------------   Currency Style          $   1,234.56   Comma Style             ____1,234.56				
REFERENCES

Microsoft Excel 7.0

For more information about the Currency style in Microsoft Excel, clickAnswer Wizard on the Help menu and type:
tell me how to change the Currency style

Microsoft Excel 5.0

"Microsoft Excel User's Guide," version 5.0, Chapter 12, "Formatting aWorksheet"

For more information about the Currency style in Microsoft Excel, clickthe Search button in Help and type:
currency style
5.00a 5.00c 8.00 97 98 XL98 XL97 XL7 XL5 XL
Properties

Article ID: 151442 - Last Review: 08/17/2005 20:40:04 - Revision: 1.3

  • Microsoft Excel 97 Standard Edition
  • Microsoft Excel 95 Standard Edition
  • Microsoft Excel 5.0 Standard Edition
  • Microsoft Excel 98 for Macintosh
  • kbprb KB151442
Feedback