Concatinating a string of numbers - how?

[drod]

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!

[Gbonda]

Use the value function.

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" <[email protected]> wrote in message
news:[email protected]...
>
> 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
>

[VBA Noob]

Or

Data > text to column

In delimter tick other and enter '

VBA Noob

[drod]

Thank you - value function worked!

[Debra Dalgleish]

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