Not updating the format
 

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.

Not updating the format
 

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

If so, change to Automatic...

" wrote:

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.