| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Changing Positive to Negative
This may be a really dumb question, but hey here goes.
I have a column of positive monetary amounts (i.e. debits). They SHOULD be negative amounts (i.e. credits). Is there a way to change all of them from positives to negatives in one go? Thanks |
|
#2
|
|||
|
|||
|
Hi
Type -1 in a blank unused cell. Copy this, select your range and then Edit|Paste Special|Multiply. Take a copy of your sheet before you start! -- Andy. "Matthew Hackett via OfficeKB.com" wrote in message ... This may be a really dumb question, but hey here goes. I have a column of positive monetary amounts (i.e. debits). They SHOULD be negative amounts (i.e. credits). Is there a way to change all of them from positives to negatives in one go? Thanks |
|
#3
|
|||
|
|||
|
Worked a treat - thank you
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Automatically put negative sign in cells with positive numeric dat | Excel Discussion (Misc queries) | |||
| Finding negative and positive diffrence | Excel Worksheet Functions | |||
| simple query changing set of numbers from positive to negative | Excel Discussion (Misc queries) | |||
| how do I rank negative and positive numbers? | Excel Worksheet Functions | |||
| How can I change positive numbers to negative, i.e. change 50 to - | Excel Discussion (Misc queries) | |||
Linear Mode
