Originally Posted by LalitPandey87 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)
View Tag Cloud
Forum Rules
Bookmarks