Formula remove decimal and keep zero.

[Russk68]

Hi
I need to keep the numbers to the right of the decimal. I always need a 3 digit number with zeros included. A 3rd decimal is never exceeded.
Before 21.450
After 450
The formula im using below returns 45 and my desired result is 450
=MID(F3,FIND(".",F3)+1,256)
TIA!

 

[Tetra201]

Try

=(F3-TRUNC(F3))*1000

 

[Russk68]

Try

=(F3-TRUNC(F3))*1000

Hi Tetra,
I tried it.
In this instance: 21.001, the result is 1 and my desired result is 001.

 

[Tetra201]

... In this instance: 21.001, the result is 1 and my desired result is 001.

You can try custom-formatting the desired cell as "000" or use an alternative approach:

=RIGHT(TEXT(F3,"0.000"),3)

 

[Russk68]

You can try custom-formatting the desired cell as "000" or use an alternative approach:

=RIGHT(TEXT(F3,"0.000"),3)

That rocks!
Thank you!!

 

[johnnyL]

If you want the integer part as well as the 3 position decimal part:

=TRUNC(F3,0) & "." & RIGHT(TEXT(F3,"0.000"),3)