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!