I am trying to change the format from number to text, and then back to
number. I am able to make the changes to the format, but when trying to
change a selection of cells that already has data in it I am unable to get
the change to take effect on all cells at one time. Instead, I have to click
into each cell, and then once I leave the cell It updates to the new format.
This is very time consuming. Is there a quicker way to update all of the
cells data?