Mike H;2379173 Wrote:
Not sure about automatic but one manual way.

Put -1 in a cell, select that cell and copy it.

Select all your cells with negative values then

Edit|paste special|multiply and click OK
delete the cell with -1 in

"TJR" wrote:
-
I am downloading banking inofrmation to a spreadsheet. It downloads as
a
negitive value. Is there a way to automaticly change this?-

Mike,
Thanks for this simple trick. I was doing this the long way - Inseret
a column, multiply by -1, then copy and paste values. It worked but
some time it shows more digits than I care for.




--
ab3d4u