Yeah the format thing works.

With the formula it doesn't I don't put the formula in the cell A6 I
put it in say A7 or anyother cell it still gives me the formula error