I have a % column that divides one column by another. For some the outcome is "#Error" due to the math #/0.. I have set a formula for if 0, then "0.0%" however doing this makes all the other calculations for that column a 10 digit long decimal... how can i fix this so i dont loose the % format of the other variables?