Changing format

[Hulkerino]

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

 

[Sheeloo]

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

 

[Hulkerino]

It worked!

Thanks a bunch!