Change a positive value to a negative value

M

Michael

I'm trying to enter a value of say $1.00 into a cell. However I want it to display a -$1.00. What formula do I use to do this?
 
J

Juan Pablo Gonzalez

You can just format the cell as

-$#,##0.00

what do you want to do for the negative values ?

--
Regards,

Juan Pablo González

Michael said:
I'm trying to enter a value of say $1.00 into a cell. However I want it
Click to expand...
to display a -$1.00. What formula do I use to do this?
 
G

Gord Dibben

Michael

Do you want to "display" -$1.00 or "be" -$1.00?

To "be" just enter as -1 and format to Currency.

To "display" just enter as 1 and format to Custom -$#,###0.00

Second case: the number will still be positive, just look negative.

Gord Dibben Excel MVP
 
Top