Do you just want to convert negative-positive (leaving positive numbers
positive)? If so, use the following formula:
=ABS(A1)

Drag this down to the end of your data. Then, copy this range and "Paste
Special"-Values over your original range.

If not, (you want to convert positive numbers to negative as well). Place
-1 in an empty cell and copy it. Then select your range of numbers and
"Paste Special"-Multiply.

Does that help?
--
Regards,
Dave


"Tedd" wrote:

How do I convert a negative number to a positive number? (without editing
every cell)