You can select an empty cell
edit|copy
select the range to fix
edit|paste special|check add

But you shouldn't have to resave for this fix or your fix, either.

JLMHoss wrote:

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?

--

Dave Peterson