extracting digits to the right of a decima point
 

This will work, I assumed cell A1, change to fit your data:

=IF(INT(A1)=A1,A1,RIGHT(A1,LEN(A1)-SEARCH(".",A1)))

--
Regards,
Dave


"steve" wrote:

Hi friends,
have a question regarding excel. I have one column in which I have numbers
like 7.5,7.25,etc. I also have numbers like 45,65,etc. I have succeded in
extracting the left digits from numbers like 7.5 by using the left function
in a IF Formula. I needed to extract only the left digit from numbers having
value below 8. This I could do . Now my question is how to extract the digits
to the right of the decimal point. Remember not all numbers have decimal
points. numbers are varied from 7.5 to 65. I need to extract the right digits
like 5 from 7.5 in numbers having decimals and not from whole numbers like
55.any help will be greatly appreciated. Have a great day.
thank you
steve