Microsoft KB Archive/22745

Displaying Negative Values in Parentheses without $ Sign PSS ID Number: Q22745 Article last modified on 07-22-1988 PSS database name: D_MPlan

3.00 3.01 3.02 3.04

MS-DOS

Question: I want to set up my Multiplan spreadsheet so that positive numbers will be displayed without any currency symbol and my negative numbers will be displayed in parentheses without any currency symbol. How do I do this?

Response: Under “Format Units-Currency”, define your currency as “Other”. In the “Currency:” field, type a blank space. This will cause your currency symbol to be a blank space. Format the cells in your worksheet where you want negative values to be displayed with parentheses to have the $ format under “Format Cells Format Code:”. This will cause the negative values to be displayed with parentheses around them and also to display the currency symbol, which, in this case has been defined to be a blank space. A number such as -34.5 will be displayed as ( 34.5). There is no way to get rid of the blank space (the currency symbol) but if you like, you can cause it to be displayed following, instead of preceding, the number by setting “Symbol First:” to “No” under “Format Units-Currency”.

Copyright Microsoft Corporation 1988.