Hi all
I an wondering if there is in VBA an easy way (formula?) to use the first 3 decimals and NOT round these up of down.
e.g: 1.2345 should become 1.234 and not 1.235
In the same way:
1 should be 1.000
11.1 should be 1.100
123.23456 should be 123.234
1.234567 should be 1.234 etc
I have thought about a detour and recalculate the decimals * 1000 and then left(...,3) but I hope there is an easier way out?
Can anyone help?
Thanks in advance
Hein
Bookmarks