=LEFT(A1,FIND(".",A1)-1)
then fill down.

"JN" wrote in message
...
Hi,

I have 4000 rows of data that start with "01Exxx.00" and tried using the
"convert text to column" function to get rid of digits after the period.
However, it all turned into "1E+123.. 1E+233".

What can I do to make the numbers show "01E123" without the ".00"? Thanks.