excel keeps changing my cell format. I am trying to link a cell to a tab called "controls" and instead of giving me the answer, the cell keeps showing "=CONTROLS!B6" I changed the format back to general, deleted the "=" then readded the "=". That works, but the minute a press F2 on that cell to recalculate, it goes back to "=CONTROLS!B6"
Solved by B. B. in 13 mins