| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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?
|
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change positive to negative number | Excel Worksheet Functions | |||
| Change from a negative to a positive | Excel Discussion (Misc queries) | |||
| change cell from negative to positive | Excel Discussion (Misc queries) | |||
| How to change negative to positive | Excel Worksheet Functions | |||
| Quick way to change negative #s to positive | Excel Discussion (Misc queries) | |||
![Michael[_31_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
