Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
counting a string of negative or positive numbers | Excel Discussion (Misc queries) | |||
How to look for a sequence of numbers in a string? | Excel Discussion (Misc queries) | |||
Incorporating Numbers into a text string | Excel Worksheet Functions | |||
Count and Sum Total occurrances of two specific numbers | Excel Worksheet Functions | |||
Converting Numbers to Text properly | Excel Discussion (Misc queries) |