Change a positive value to a negative value

[Guest]

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?

 

[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

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?

 

[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