Thanks for the quick response, the code works but it only allows on
number in column C to be negative at a time so say I have 25 rows i
Column C with that condition only one converts to a negative number
I'm trying to add all those numbers in Column C up so I need al
corresponding cells to turn negative so my total is correct. Thank

--
Message posted from http://www.ExcelForum.com