Convert negative to positive in sheet containing both positive/negative numbers

I have few huge sheets with thousands of rows of data (and lots of columns). It contains both negative and positive numbers. I would like to convert negative nubmers to positive before I can start creating pivot table on this data. Any suggestions?

Thank you,
Jay

Yes, use the ABS formula

You could select the area of interest and run this:

Please Login or Register  to view this content.

My take...This will convert all the numeric cells on the active worksheet to their positive value:

Please Login or Register  to view this content.

If you want the macro to do all the worksheets in the activeworkbook, then:

Please Login or Register  to view this content.