Thread: Change a positive value to a negative value
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default 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?

Reply With QuoteReply With Quote