Works: How to Format Negative Numbers in Parentheses (242403)


The information in this article applies to:

  • Microsoft Works 2000
  • Microsoft Works 6
  • 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.
  4. Click OK, and then close Control Panel.
  5. Format the numbers in your database or spreadsheet as either Currency or Comma.
Modification Type:MajorLast Reviewed:6/29/2004
Keywords:kbdisplay kbenv kbhowto KB242403
©2004 Microsoft Corporation. All rights reserved.