the formatnumber() function does not display decimal numbers that have more than 3 decimal

i have next code

Please Login or Register  to view this content.

when I apply my macro each number for example 34563,9843 is displayed in the format 34,563.98 when I enter the number of decimal places 3 or 4 or 5. when I select the number of decimal places 1 the display in excel is 34,563.90. the display after the separator and decimals is fine with the menu, but why doesn't it display decimal places larger than 2.
I have the same problem with the percentage format.
I noticed when I entered the number of decimal places. This number actually rounds to that number of decimal places, and a always shows 2 decimal places

Maybe something to do with setting the NumberFormat of the selection to "###,###,###,###0.00" ...?