Right function with second decimal place is 0

[t0azt]

How do I get the right function to pick up 0 as the second decimal place?

I'm trying to get zero from =RIGHT(A1) where A1 is 2,366,125.60 but excel is picking up the 6 since it drops the last zero.

Thanks

 

[DanteAmor]

Maybe the format of the cell has 2 decimals.
That's why you can not get zero,
Test with 123.45 should result 5

 

[t0azt]

It works with all decimals except 0. The cells are formatted to include 2 decimal places.
so 123.45 will give me 5 but 123.40 will give me 4 and I need 0

 

[joeu2004]

Excel does not pay any attention to cell format when you reference a numeric cell in a formula. In fact, if the value in A1 were 123.543 formatted to display 2 decimal places (appears to be 123.54), RIGHT(A1) would return 3.

If you always want the 2nd decimal place (rounded), write RIGHT(TEXT(A1,"0.00")).

However, if you always want the right-most displayed digit (character), I think you will need to use a VBA function. For example:

Function myRight(c As Range, n As Long) As Variant
myRight = Right(c(1).Text, n)
End Function

 

[Tetra201]

Try

=RIGHT(TEXT(A1,".00"))

 

[DanteAmor]

We all know that after the point the zeros to the right do not work.

Then let there be zero

=RIGHT(TEXT(A1,".00"),1)

 

[t0azt]

Perfect. Thank you all!

 

[DanteAmor]

I'm glad to help you. Thanks for the feedback.