CODEWITHSUNDEEP
excel
Kannan Karmegam
Kannan Karmegam

Reputation: 661

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 accomplish this.

Upvotes: 0

Views: 2647

Answers (1)

JYelton
JYelton

Reputation: 36512

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

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

Upvotes: 2

Related Questions