Convert numbers to text
sorry my solution will convert your text numbers to numbers. I don't know if
that would be helpful.
"Nikki" wrote:
copy and empty cell-- edit-- special paste--select value & add
select OK... now you should see numbers.
hope it works for you.
"Gary Hopkins" wrote:
Marcelo, thanks for the quick reply. However, I did try formatting the cells
to text, and it did not seem to work.
I'm using vertical looking and comparing some numbers to another group of
numbers that were originally pasted in as text, so it's not working since
the first group is numbers and not text. The formatting of the cells to text
did not seem help and the vlookup returned the result of #N/A. If I put the
apostrophe in front of the numbers, the vlookup does return the result I'm
looking for.
Thanks
Gary
"Marcelo" wrote in message
...
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
|