How to format negative currency as red with a negative sign?

[Dab]

I prefer positive numbers which are currency to be black, and negative
numbers which are currency to be displayed in red along with the negative
sign. Do you have to use a "Custom" format to accomplish that? If so,
do you know what that would be? Thanks in advance.

 

[Dave]

Hi,
I run XL2000, so not sure if this will be the same for your version.
Select your cell, then Format > Cells
On the Number tab, select currency.
You will see a list of options as to how negative numbers are displayed. In
my version, the one you want is 4th.
Regards - Dave.

 

[Bernard Liengme]

$#,##0.00;[Red]-$#,##0.00
Just replace $ by required symbol
best wishes

 

[Dab]

$#,##0.00;[Red]-$#,##0.00
Just replace $ by required symbol
best wishes

I'm using Excel 2007 and saving as .xlsx. I selected custom format and
pasted the above in and it didn't work (negative numbers didn't appear
red). The above does appear to work if I'm working on an xls file
[compatibility mode]. Any ideas how to get things working with xlsx
files?

 

[Bob Phillips]

Worked fine for me. I added it via the dialog on the Number group of the
Home tab.

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)

$#,##0.00;[Red]-$#,##0.00
Just replace $ by required symbol
best wishes

I'm using Excel 2007 and saving as .xlsx. I selected custom format and
pasted the above in and it didn't work (negative numbers didn't appear
red). The above does appear to work if I'm working on an xls file
[compatibility mode]. Any ideas how to get things working with xlsx
files?