I have a problem on cell formatting.

The initial column format is Text but I tried to reformat it Number with separator. But there was no effect.

The worksheet and cells are not locked/protected. After clicking the formula bar then hightlight any cell again. That particular cell change to the expected format.

Is there a way to refresh all the cells in one go? so that I do not have to click every single cell to make it works.

Thanks.