Say you have numbers in A1 thru A100 and need text. Format B1 thru B100 as
Text.

Then copy A1 thru A100 and paste/special/value onto column B. Your data
will be in Text format.

You can do the same in reverse.
--
Gary''s Student - gsnu200834


"ZZ top" wrote:

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?