Find last three digits after . ( including zero)

[LearnerExcel]

How to get last 3 digits after "." (Decimal) including zero ? The following formula doesn't work?

 =RIGHT(A1,3)

Example: 88,485.90 ----------- The result is 5.9 (But I need here .90 inculding last ZERO)
88,485.95 ----------- The result is .95 (Here it is okay as it gets last 3 digits after Decimal)

How to modify the formula?

[LearnerExcel]

 
=A1-TRUNC(A1)

Problem resolved.

[Alsadius]

Originally Posted by LearnerExcel

 
=A1-TRUNC(A1)

Problem resolved.

That'll get him all decimals, not just the last three.

Assume we're dealing with 123.456789.

=A1-TRUNC(A1)
will result in 0.456789

=ROUND(A1-TRUNC(A1), 3)
will result in 0.457 (it rounds it off to three decimal places)

=(TRUNC((A1-TRUNC(A1))*1000))/1000
will result in 0.456 (this is a nasty formula, but it basically shifts the decimal three places and re-truncates)

=RIGHT(A1-TRUNC(A1), 3)
should result in 789 (though this one gave me a floating-point error when I tried it, which may mean it's bug-prone in practice and needs caution)

Which one you want depends on exactly what you're trying to do, but hopefully that should cover all the bases.

[ArviLaanemets]

=rounddown(a1,3)-trunc(a1)

[jolivanes]

 
=text(right(a1, 3),"0.00")