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