Not updating the format

[sweetpotatop]

Hi,

I was trying to change the format of the cells in Excel. However, you
won't see the change until you enter the edit mode then press enter.
Is there a way to update the format of cell without going to the edit
mode? As I have tons of rows that require this format.

Thanks in advance.

 

[Sean Timmons]

Check to see if you are on Manual Calculation - Tools - Options - Calculation.

If so, change to Automatic...