=LEFT(A1,FIND(".",A1)-1)

That formula resturns the number as TEXT.

Try it like this to return the number as a NUMBER.

=--LEFT(A1,FIND(".",A1&".")-1)

--
Biff
Microsoft Excel MVP


"Data Analyst" wrote in message
...
What if I have Prime Numbers in the column..how can I keep them as is with
this formula?

"Gary''s Student" wrote:

=LEFT(A1,FIND(".",A1)-1)
--
Gary''s Student - gsnu201001


"Data Analyst" wrote:

Here is the issue: I have numbers like this one - 10000.01.01.200

I just want the prime number 10000. How can I do that? I tried Ctrl+F
and
replace but is there a more efficient way?

Thanks!