Prev: How do i hide carriage returns?
Next: MS Excel 2007 "Recent" files not updating
From: Emece on 28 May 2010 13:00
I have a column with the following data:

A
RUT 212874790014

Each cell has the word RUT, and the number changes, altough it always has 12
digits. I need to have the word in one cell and the number in another, so I
use the text to column option. But when I finish doing this the result is:

A B
RUT 21,2875E+11

How can I avoid this, so as to keep displaying the whole original number in
the cell?

Thanks in advance.

Regards,
Emece.-
From: tim m on 28 May 2010 13:09
After performing the text to columns, format the number column as 'number'
zero decimal points.

"Emece" wrote:

> I have a column with the following data:
>
> A
> RUT 212874790014
>
> Each cell has the word RUT, and the number changes, altough it always has 12
> digits. I need to have the word in one cell and the number in another, so I
> use the text to column option. But when I finish doing this the result is:
>
> A B
> RUT 21,2875E+11
>
> How can I avoid this, so as to keep displaying the whole original number in
> the cell?
>
> Thanks in advance.
>
> Regards,
> Emece.-
From: Gord Dibben on 28 May 2010 13:26
If you don't need that number for calculations.

In Step 3 set Column Data Format to Text for that column.

Elsewise format as number.....no DP


Gord Dibben MS Excel MVP

On Fri, 28 May 2010 10:00:01 -0700, Emece <Emece(a)discussions.microsoft.com>
wrote:

>I have a column with the following data:
>
>A
>RUT 212874790014
>
>Each cell has the word RUT, and the number changes, altough it always has 12
>digits. I need to have the word in one cell and the number in another, so I
>use the text to column option. But when I finish doing this the result is:
>
>A B
>RUT 21,2875E+11
>
>How can I avoid this, so as to keep displaying the whole original number in
>the cell?
>
>Thanks in advance.
>
>Regards,
>Emece.-

From: Emece on 28 May 2010 13:45
Thanks Tim. This works, but is there a way to specify that directly in the
wizard Text to Columns?

Thanks again

"tim m" wrote:

> After performing the text to columns, format the number column as 'number'
> zero decimal points.
>
> "Emece" wrote:
>
> > I have a column with the following data:
> >
> > A
> > RUT 212874790014
> >
> > Each cell has the word RUT, and the number changes, altough it always has 12
> > digits. I need to have the word in one cell and the number in another, so I
> > use the text to column option. But when I finish doing this the result is:
> >
> > A B
> > RUT 21,2875E+11
> >
> > How can I avoid this, so as to keep displaying the whole original number in
> > the cell?
> >
> > Thanks in advance.
> >
> > Regards,
> > Emece.-
 | 
Pages: 1
Prev: How do i hide carriage returns?
Next: MS Excel 2007 "Recent" files not updating