If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Easy way to make negative data positive?
I have a large section of negative data that I want to convert to positive
i.e. - 2 becomes 2 etc. Is there a quick way to do this? Thanks! |
#2
|
|||
|
|||
Easy way to make negative data positive?
Sarah -
Select a blank cell somewhere and enter -1. Edit | Copy. Select the range of cells containing numbers to be converted. Edit | Paste Special | Multiply. - Mike www.mikemiddleton.com "Sarah" wrote in message ... I have a large section of negative data that I want to convert to positive i.e. - 2 becomes 2 etc. Is there a quick way to do this? Thanks! |
#3
|
|||
|
|||
Easy way to make negative data positive?
Aaaah - simple is best - thanks!
"Mike Middleton" wrote: Sarah - Select a blank cell somewhere and enter -1. Edit | Copy. Select the range of cells containing numbers to be converted. Edit | Paste Special | Multiply. - Mike www.mikemiddleton.com "Sarah" wrote in message ... I have a large section of negative data that I want to convert to positive i.e. - 2 becomes 2 etc. Is there a quick way to do this? Thanks! |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Formula to make Negative Values Positive & Positive Values Negative? | mustard | General Discussion | 4 | September 26th, 2005 10:05 PM |
How do I save an access document in word document? | cmartin | General Discussion | 2 | September 13th, 2005 11:26 PM |
Format on data to import to Access tables? (I need your advice) | Niklas Östergren | General Discussion | 5 | December 13th, 2004 02:54 PM |
How do I get 3 series in sync with the x-axis? | zizbird | Charts and Charting | 10 | October 25th, 2004 01:23 PM |
MAKE EASY MOENY | Rajkovaca Ante | Worksheet Functions | 0 | January 2nd, 2004 09:51 PM |