Excel

[SGM]

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

 

[joeu2004]

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

On way: Format > Cells > Number > Accounting.

 

[Gord Dibben]

If negative brackets are not available in the
Format>Cells>Number>Number>Negative Numbers dialog.

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

Start>Settings>Control Panel>Regional and Language Settings>Regional
Options>Customize>Currency>Negative 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 OK>Apply your way out.


Gord Dibben Excel MVP