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

Negative value to positive 13
Program buttons to create a word document 0
Change the colour of a neighbouring cell 6
IF Statement accepting only positive values 1
XIRR Giving Negative Number on Positive Cash Flow Stream 11
change a positive number to negative 16
Add "+" plus symbol for a positive percentage 4
Automatic display positive or negative 3

Top