Change a positive value to a negative value
 

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?

Change a positive value to a negative value
 

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" wrote in message
...
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?

Change a positive value to a negative value
 

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

On Fri, 23 Apr 2004 12:06:07 -0700, "Michael" wrote:

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?