the CF does not alter the formula, it just hides the results. select any of the blank looking cells and you will see that the formulas are still present