Select your ranges Ctrl+H Find what: - Replace with: leave
blank Replace All


"Harshad Mehta" wrote:

Entire column has -ve numbers, wants to chage it to +ve numbers, with just
one step.
I have hundreds of colums to be changed
I will appreciate any help I can get. .