try...
Select the column
Choose Data-Text to column
Click Next and click Finish

"Hulkerino" wrote:

Hello,

Sometimes when I change format for a range of cells (ex. Text to Number),
the formatting doesn't automatically display. I know I can hit F2 to update
one cell at a time. Is there a way to update the entire range at once?

Thanks