Concatinating a string of numbers - how?
Okay, so here is my dilema. In a column, I have numbers like 123456789 and 234567890 (all are 9 digits long). However, when you select the cell, you can see that each of them is preceeded by a " ' " character that apparently is hidden from view. For example '123456789 and '234567890. I need to format these cells, but in order to do so, I need to get rid of the " ' " character preceeding each of the numbers in my column. Is there a way to concatenate or convert each of the numbers such that they no longer have the " ' " preceeding them? Thanks in advance! -- drod ------------------------------------------------------------------------ drod's Profile: http://www.excelforum.com/member.php...fo&userid=4595 View this thread: http://www.excelforum.com/showthread...hreadid=567628 |
Concatinating a string of numbers - how?
Hi
The ' merely tells Excel that what is following is text. It does not display in Excel but means that the cell is treated as a text cell. The benefit of this is that leading zeroes show and 'numbers' of more than 15 digits will show (but cannot be calculated) If you use: =A2&B2 this will concatenate the two cells - ignoring the ' Hope this helps. Andy. "drod" wrote in message ... Okay, so here is my dilema. In a column, I have numbers like 123456789 and 234567890 (all are 9 digits long). However, when you select the cell, you can see that each of them is preceeded by a " ' " character that apparently is hidden from view. For example '123456789 and '234567890. I need to format these cells, but in order to do so, I need to get rid of the " ' " character preceeding each of the numbers in my column. Is there a way to concatenate or convert each of the numbers such that they no longer have the " ' " preceeding them? Thanks in advance! -- drod ------------------------------------------------------------------------ drod's Profile: http://www.excelforum.com/member.php...fo&userid=4595 View this thread: http://www.excelforum.com/showthread...hreadid=567628 |
Concatinating a string of numbers - how?
Use the value function. -- Gbonda ------------------------------------------------------------------------ Gbonda's Profile: http://www.excelforum.com/member.php...fo&userid=8758 View this thread: http://www.excelforum.com/showthread...hreadid=567628 |
Concatinating a string of numbers - how?
Or Data text to column In delimter tick other and enter ' VBA Noob -- VBA Noob ------------------------------------------------------------------------ VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833 View this thread: http://www.excelforum.com/showthread...hreadid=567628 |
Concatinating a string of numbers - how?
Thank you - value function worked! -- drod ------------------------------------------------------------------------ drod's Profile: http://www.excelforum.com/member.php...fo&userid=4595 View this thread: http://www.excelforum.com/showthread...hreadid=567628 |
Concatinating a string of numbers - how?
There are instructions here for converting text numbers to real numbers:
http://www.contextures.com/xlDataEntry03.html drod wrote: Okay, so here is my dilema. In a column, I have numbers like 123456789 and 234567890 (all are 9 digits long). However, when you select the cell, you can see that each of them is preceeded by a " ' " character that apparently is hidden from view. For example '123456789 and '234567890. I need to format these cells, but in order to do so, I need to get rid of the " ' " character preceeding each of the numbers in my column. Is there a way to concatenate or convert each of the numbers such that they no longer have the " ' " preceeding them? Thanks in advance! -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
All times are GMT +1. The time now is 06:05 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com