Quote Originally Posted by LalitPandey87 View Post
Thanks Rick for your quick response but i was just asking is there any other formuls to do the same or not.
Okay, two other possibilities then...

=1*LEFT(F2,FIND(".",A2&"."))

=ROUNDDOWN(A2,0)