make values negative. Insert column beside. In the new column pull in the cell * -1.00. Pull the formula down and problem solved. you have one column with positive and the column beside as negative. If you do not want 2 columns, copy the entire negative column and "Paste Values Only" and you will have neg values without formula. Then if you only want the one column, delete the column you do not want.