Change from a negative to a positive

E

Erica

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!
 
I

Imajica12345

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

change a positive number to negative 16
Help with positive and negative numbers 1
Automatic display positive or negative 3
Using a negative figure as positive 5
Excel VBA to match positive and negative transactions 3
Reallocate array cells value from positive to negative 0
Change negative nmbr to positive 7
How do I subtract a negative number from a positive number? 4

Top