How can I refresh cells after changing the format?

J

JLMHoss

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?
 
D

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.
 
G

Gord Dibben

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

Tools>Options>Calculation. Set to automatic.


Gord Dibben MS Excel MVP
 
Top