Microsoft KB Archive/832285

= The negative number inside parenthesis format is not available in Excel for numbers or for currency =

Article ID: 832285

Article Last Modified on 7/27/2006

-

APPLIES TO


 * Microsoft Office Excel 2003
 * Microsoft Excel 2002 Standard Edition
 * Microsoft Excel 2000 Standard Edition

-



SYMPTOMS
When you try to format cells in Microsoft Excel that contain a negative number inside parenthesis, such as for currency ($1,234.10) or for numbers (1234.10), the format is not available.



CAUSE
This behavior may occur if you select a non-English (United States) location as Your Locale (location) on the General tab of your Regional Options (click Start, point to Settings, and then click Control Panel).



RESOLUTION
To correct this behavior, change the default negative number format when you use a non-English (United States) location as Your Locale (location). To do this, use one of the following methods.

Method 1: For Microsoft Windows XP
 Click Start, and then click Control Panel. Click Date, Time, Language, and Regional Options. Click Regional and Language Options. On the Regional Options tab, follow these steps:  In the Select an item to match its preferences, or click Customize to choose your own formats box, select the location that you want. Click Customize. On the Numbers tab, change the Negative number format box to the format that you want, such as (1.1).</li> On the Currency tab, change the Negative currency format box to the format that you want, such as ($1.1).</li> Click Apply.</li> Click OK to close the Customize Regional Options dialog box.</li></ol> </li> Click OK to close the Regional and Language Options dialog box.</li></ol>

Method 2: For Microsoft Windows 2000

 * 1) Click Start, point to Settings, and then click Control Panel.
 * 2) Double-click Regional Options.
 * 3) On the General tab, change the Your locale (location) box to the location that you want.
 * 4) On the Numbers tab, change the Negative number format box to the format that you want, such as (1.1).
 * 5) On the Currency tab, change the Negative currency format box to the format that you want, such as ($1.1).
 * 6) Click Apply.
 * 7) Click OK to close the Regional Options dialog box.

<div class="moreinformation_section">

MORE INFORMATION
To select the cell format that you want to use in Excel, follow these steps:
 * 1) Start Excel and open your worksheet.
 * 2) Select the cell or cell range that you want to format.
 * 3) On the Format menu, click Cells.
 * 4) On the Number tab, click the Category that you want to change--for example, click Currency.
 * 5) In the Negative numbers list, select the format that you want.
 * 6) Click OK to close the Format Cells dialog box.

Additional query words: English (Canada)

Keywords: kbprb KB832285

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.