Why is it that when i format some cells (containing numbers) as text, the
formatting is not applied immediately? I've had to "F2 + enter" each cell to
get the changes to take effect. What am I doing wrong?