Manual

Enter -1 in a empty cell
Copy this cell

Select your cells and right click on them
Choose Paste Special..Multiply
OK

You can do this with VBA also

--
Regards Ron De Bruin
http://www.rondebruin.nl



"JimMay" wrote in message news:H%Ggg.40308$fG3.11689@dukeread09...
I need (In VBA code) to convert a varying range of values,
Say Range("E6:E" & Lrow) from:
-123
-234
-345
-456

To:

123
234
345
456

But can't quite get it going here;
Can someone show me how?

TIA,

Jim