Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change from a negative to a positive
I am working on a buget and need to use the information from one sheet
carried over to another sheet. On the original sheet it is considered a negative number but I need it carried over as a positive number. The formula I am using is: =+'OTHER W'!B19 Thank you! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change from a negative to a positive
would:
=-'OTHER W'!B19 work? On 11 Gru, 20:26, Erica wrote: I am working on a buget and need to use the information from one sheet carried over to another sheet. On the original sheet it is considered a negative number but I need it carried over as a positive number. The formula I am using is: =+'OTHER W'!B19 Thank you! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change from a negative to a positive
Hi,
Perhaps this would work... 1. On the new sheet put a -1 in a blank cell (you can delete this after) 2. Highlight cell with -1 and control-c to copy 3. highlight rows/columns with data you want to change from neg to pos 4. Click on the Edit Menu and select Paste Special 5. Select "multiply" 6. Click OK Now all the data in the cells you selected should be multiplied by -1 which in effect will change all your neg numbers to pos. 7. You can now delete the -1 from the original cell. Regards, Michael "Erica" wrote: I am working on a buget and need to use the information from one sheet carried over to another sheet. On the original sheet it is considered a negative number but I need it carried over as a positive number. The formula I am using is: =+'OTHER W'!B19 Thank you! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change from a negative to a positive
You want the absolute value.
=ABS('Other W'!B19) -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Erica" wrote: I am working on a buget and need to use the information from one sheet carried over to another sheet. On the original sheet it is considered a negative number but I need it carried over as a positive number. The formula I am using is: =+'OTHER W'!B19 Thank you! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Change negative nmbr to positive | Excel Discussion (Misc queries) | |||
Change cell value from positive to negative | Excel Discussion (Misc queries) | |||
Change negative amount to positive. | New Users to Excel | |||
change cell from negative to positive | Excel Discussion (Misc queries) | |||
How to change negative to positive | Excel Worksheet Functions |