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

  • Thread starter Thread starter Dab
  • Start date Start date
D

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.
 
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 said:
$#,##0.00;[Red]-$#,##0.00
Just replace $ by required symbol
best wishes
Click to expand...

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?
 
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)



Dab said:
Bernard Liengme said:
$#,##0.00;[Red]-$#,##0.00
Just replace $ by required symbol
best wishes
Click to expand...

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?
Click to expand...
 
Back
Top