Re: Make all numbers positive?

[Norman Harker]

Hi Tom!

One way is to set up a parallel column and use:

=ABS(A1)
Copy down

If you want to replace the original data, then:
Select the cells with formulas
Edit > Copy
Edit > Paste Special
Select Values
OK

You can now copy and paste these over the original data and delete the
column that you have inserted.
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
Holidays and Observances Sunday 27th July: Cuba (Revolution Day),
Djibouti (Independence Day), Hong Kong (Lu Pan Day), North Korea
(Victory Day), Puerto Rico (Barbosa Day), Russian Federation (Navy
Day)
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[Tom H. Lautenbacher]

=ABS(A1)

Thanx again for your help, Norman!

Cu,
Tom.

 

[Norman Harker]

Hi Tom!

Thanks for thanks. If you want to change the original data, Orlando's
approach is much better. Or you can adapt Orlando's method by copy the
data to an adjacent column and performing the replace operation there.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
Holidays and Observances Sunday 27th July: Cuba (Revolution Day),
Djibouti (Independence Day), Hong Kong (Lu Pan Day), North Korea
(Victory Day), Puerto Rico (Barbosa Day), Russian Federation (Navy
Day)
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.