Use the first 3 decimals in stead of rounding

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

Hi Hein,

Suppose you data is in A2 cell below is the VBA Code also updating the formula for your reference.

Please Login or Register  to view this content.

Regards,
lokicl

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save


You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.

Thank you Rory (again!)

I didn't know about this CLng - feature but it works
I thought there had to be an easier way to achieve my goal, and there was

Thanks again
Hein

Hi lokicl

Thank for your contribution, but as you can see from my reply to romperstomper his solution works for me.
I will copy and save your suggestion in my suggestion file and use it when appropriate
Thanks again
Hein