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.-

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.-

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
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.-

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.-