Excel Right function

I have a excel sheet with cell value 0.010, 0.020 etc., I want to get the values 3 digits after the decimal ie., "010" "020" etc., If I use the Right function Right(cell,3) it returns me ".01" ".02". The reason is the Right function ignores the "0" at the end of decimal point. Is there any other function that accompl开发者_运维知识库ish this.

You probably first need to convert the numeric value to a string:

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