How can I refresh cells after changing the format?

[Guest]

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]

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.

 

[Gord Dibben]

You may be in manual calculation mode. and calculating upon Save

Tools>Options>Calculation. Set to automatic.


Gord Dibben MS Excel MVP