Excel Help

[oHUTCHYo]

Guys,

Need your help please. I won't explain the boring reasons, but the workflow is as follows;

I need numbers that are currently 6 decimal places, but only the first 3 decimal places are to be used, specifically as shown to the user when formatted to display 3 decimal places.

Example
So, we have currently, 0.590487. I want to use only 0.590.

I have used TRUNC, which works on that number. However on a number showing as 0.493, but is actually 0.492733, its giving me 0.492 when TRUNC'd - when I want to take the 0.493.

TL;DR - I want to truly copy and paste the 3 decimal place numbers in a list as SHOWN, without consideration for the 6 decimal place behind it. TRUN does not work as I would like.

Hope I have explained that correctly!

 

[Mirmo]

Morning,

If I'm reading which way round you want it correctly, the round function is what you're after. =round(which cell,how many decimals you want it to show)
It will show the first three decimals but will round it correctly using any relevant numbers after the third.

 

[Mirmo]

Just to add:

if 0.492733 is in cell A1 then =round(A1,3) will give 0.493.

 

[oHUTCHYo]

Mirmo, your a gentleman, thank you sir!

 

[Mirmo]

No worries m8