Hello everyone
I have a number in Range("D6") which is 57439.25

I need to analyze the number in range("G6:G9") so as to get the results as following :
50000 In G6
7000 In G7
400 In G8
39 In G9

and ignore that part 0.25

If possible I prefer UDF function to do that task
Thanks advanced