Convert numbers to text
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 |
Convert numbers to text
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 |
Convert numbers to text
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 |
Convert numbers to text
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 |
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 |
Convert numbers to text
Gary, try to test if the both figures (numbers and text) return true if
compared =a1=b1 if it's false, and I think will be, try to use =text(a1,"####") regards "Gary Hopkins" escreveu: 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 |
Convert numbers to text
Thanks again! Right before I opened up this post I think I figured it out.
I used the formula TEXT(A1,0) and it seems to work perfectly now. Have a good day! Gary "Marcelo" wrote in message ... Gary, try to test if the both figures (numbers and text) return true if compared =a1=b1 if it's false, and I think will be, try to use =text(a1,"####") regards "Gary Hopkins" escreveu: 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 |
Convert numbers to text
You can also go to data--text to column--select next, selct next again and
in cloumn data format select Text..this will convert your numbers to text. Regards- "Gary Hopkins" wrote: Thanks again! Right before I opened up this post I think I figured it out. I used the formula TEXT(A1,0) and it seems to work perfectly now. Have a good day! Gary "Marcelo" wrote in message ... Gary, try to test if the both figures (numbers and text) return true if compared =a1=b1 if it's false, and I think will be, try to use =text(a1,"####") regards "Gary Hopkins" escreveu: 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 |
All times are GMT +1. The time now is 04:31 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com