if you want to make a numeric value absolute, maybe use abs function. Abs(Range("A3").value))