Thanks!! What do the LEFT and Find functions do here? Also, can I apply this
formula for any number text with "E" in it?

"Bob Umlas" wrote:

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