If the data is in column A, use a helper column and enter = -A1 and drag down.

If the data also contains positive number that you wish to remain positive
i.e. turn all figures into hash values, enter =If(A1<0,-A1,A1) into the
helper column and drag down.

HTH

"klafert" wrote:

I know I done this before but I am drawing a blank. I am exporting a report
from Crystal Report. I the column contains negative figures. In Crystal I
can tell it to "reverse the sign to display". In other words I can have a
negative show as a postive. However, when I export into Excel it imports as
a negative. I know there is a way to change a negative number to a positive
number in
Excel. Need help ASAP!!!