hi Gary,

select the range and format as a text

hth
regards from Brazil
Marcelo

"Gary Hopkins" escreveu:

Hi, how can I convert a number in a cell to a text value?

Normally I would just edit my cell and put an apostrophe in front of the
number to make it a text cell, however I don't see doing this to 1000+ rows
as something very fun and I'm sure there must be a different way of doing
this.. ?

Thanks

Gary