G Guest Apr 23, 2004 #1 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?
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 Apr 23, 2004 #2 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?
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 Apr 23, 2004 #3 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
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
