Ah that would be a good way to round. Simple yet effective. Clever, thank you. After I posted I found a similar method to truncate, ie: A =(A/10)*10.
Unfortunately, I think my number must be too big or something as it is exploding when I try these types of things. Even when splitting up into seperate lines and/or variables, it still explodes. I should have mentioned in my first post that this number is an 9 digit 32 bit number.
Even this wont do it (500002816 is just a random example I made up), it still explodes:
A = 500002816
B = A/10
C = A * 10
I did this which is working but sure feels like a hack.
A = 500002816
B$ = STR$(A,9)
C$ = MID$(B$,1,8)
D = VAL(C$)
It's working but there must be a better way??? At this point rounding would be stupendous but a clean method of truncating would be a start.