Trouble pulling a string of numbers due to it being a decimal...

**DSully82** · 05-16-2013, 09:52 PM

The problem I'm having is that I want a cell (A5) to equal the final 2 numbers of another cell (D2). I tried using the =right fx, and the =mid(find) fx. I'm running into a problem because the two digits I'm trying to pull are part of a decimal (1.060). So I want A5 to equal 60, but instead it just keeps giving me 6 or 06. If I change 1.060 to 1.063 it adjusts and gives me 63.

Any ideas on how to tell Excel to give me that zero?

Thanks!
-Dave

**Tony Valko** · 05-16-2013, 10:02 PM

Are the numbers always out to 3 decimal places?

**Lemice** · 05-16-2013, 10:07 PM

Hello and welcome to the forum,

Maybe this formula is what you are looking for
=RIGHT(TEXT(C1,"#.##0"),2)

This formula works assuming you have at most 3 digits after the decimal. So 1.06, 1.060 and 129318293.06 will all returns the value of 60.

And of course for the case 1.063, it will return 63.

Note that the question on post #2 from Tony Valko is very important, because if you enter a number with more than 3 digits after the decimal, it will only take the second and third digit after the decimal.

**DSully82** · 05-16-2013, 11:01 PM

Perfect - Thanks!

**Lemice** · 05-16-2013, 11:05 PM

Glad that I could help.

If you have found a fitting solution to your problem, please mark the Thread as [SOLVED] using the Thread Tools right above post #1. It keeps things neat and tidy.

And don't hesitate if you have any question.

Have a great day.