Why not =left(a1,4)? That will give you the same value.

Also, Left returns text. If you want to use it as a number in calculations,
use:
=--left(a1,4)

I still think you are better off checking for the decimal point, as shown in
previous posts.

Regards,
Fred

"Data Analyst" wrote in message
...
Found it! It's =LEFT(A1,6)

6 is the number of characters that will be used from Left to Right

"Data Analyst" wrote:

=LEFT(A1,FIND(".",A1,1)-1) doesn't work...anything else?

"Data Analyst" wrote:

I'm using the following formula to remove decimals from my fields (ex.
1000.02.09.03):

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

I need to include in it the fields that don't have decimals (ex. 1000)
to be
calculated as is instead of receiving the error message #VALUE!