Removing Decimals and Calculating Prime Number Fields

  • Thread starter Thread starter Data Analyst
  • Start date Start date
D

Data Analyst

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!
 
To remove the decimals (as requested), use Substitute. For example, to
change it to the number 1000020903, use:
=--substitute(a1,".","")

Regards,
Fred
 
Found it! It's =LEFT(A1,6)

6 is the number of characters that will be used from Left to Right
 
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
 
Back
Top