Cells do not automatically change when the number format is changed. You
have to edit the cell and resave before the new format takes effect. Try
it...if you change a range from General format to text format, the cells will
not indicate a format change until you open each cell with F2 and press enter.

Is there an easy way to globally refresh a range of cells that have had a
format change?