Excel
 

how do i set up $(230) for negative values instead of "-" in excel

Excel
 

On Aug 3, 9:37*am, SGM wrote:
how do i set up $(230) for negative values instead of "-" in excel

On way: Format Cells Number Accounting.

Excel
 

If negative brackets are not available in the
FormatCellsNumberNumberNegative Numbers dialog.

This is a function of your Regional Settings in Windows OS.

StartSettingsControl PanelRegional and Language SettingsRegional
OptionsCustomizeCurrencyNegative Currency Format. Click on drop-down
arrow
and select the ($1.1)

Note: this is under the "Currency" tab in Regional Options. Changing under
the "Numbers" tab only does not do the trick.

Apply and OKApply your way out.


Gord Dibben Excel MVP

On Sun, 3 Aug 2008 09:37:00 -0700, SGM
wrote:

how do i set up $(230) for negative values instead of "-" in excel