Microsoft KB Archive/242403

= Works: How to Format Negative Numbers in Parentheses =

Article ID: 242403

Article Last Modified on 1/25/2007

-

APPLIES TO


 * Microsoft Works 2000 Standard Edition
 * Microsoft Works 6.0
 * Microsoft Works Suite 2000
 * Microsoft Works Suite 2001

-



This article was previously published under Q242403



SUMMARY
This article describes how to make negative numbers in a Microsoft Works database or spreadsheet be displayed in parentheses (instead of being preceeded by a hyphen).



MORE INFORMATION
To format numbers in a Works database or spreadsheet so that negative numbers are displayed in parentheses:
 * 1) Click Start, point to Settings, and then click Control Panel.
 * 2) Double-click Regional Settings.
 * 3) On the Currency tab, click the down arrow next to Negative Number Format, and then click ($1.1).

NOTE: You must select the ($1.1) format that does not show a space between the currency symbol and the number.
 * 1) Click OK, and then close Control Panel.
 * 2) Format the numbers in your database or spreadsheet as either Currency or Comma.

Additional query words: w_works works2k w2001

Keywords: kbdisplay kbenv kbhowto KB242403

-

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

© Microsoft Corporation. All rights reserved.