I use this piece VBA code to truncate the input numbers in Excel but in some cases it still round the number rather than truncating them. When I try some specific numbers, it does NOT work. The examples I found are: 1.11116, 17.84116.
I use this piece VBA code to truncate the input numbers in Excel but in some cases it still round the number rather than truncating them. When I try some specific numbers, it does NOT work. The examples I found are: 1.11116, 17.84116.
These are the only numbers I came across that the code does not work on. Both end with a 6, but there is no pattern to the issue.
This is the code:
Does anyone have any ideas why this is happening and how to fix it? Thanks.Please Login or Register to view this content.
Bookmarks