Changing the value

**nicodam** · 10-21-2009, 08:14 AM

I have dataset containing several hundred numbers, but some are minus and some are plus, how do I convert the minus into plus?

**zbor** · 10-21-2009, 08:20 AM

In next column write: =ABS(A1) and pull down.

**D_Rennie** · 10-21-2009, 08:29 AM

hello
try

Please Login or Register  to view this content.

if the values are in a range you will be able to loop through them all
if you have trouble let me know what the range is
hope it help

**darkyam** · 10-21-2009, 08:51 AM

You could also hit Ctrl+H, finding - and replacing with nothing, if there are no formulas in these numbers you're trying to make positive.

Re: Changing the value