# Need the number after the decimal only

#### daniels012

##### Well-known Member
I need to use the number after the decimal in a formula. How do I get that?

If cell C5 = 1.08345246 or 1654.083452156

I want the result to just be the right of the decimal. And use it in an equation if possible.

Thank You,
Michael

### Excel Facts

When they said...
When they said you are going to "Excel at life", they meant you "will be doing Excel your whole life".

#### shajueasow

##### Well-known Member
Are you looking for the function RIGHT?

#### RalphA

##### Well-known Member
Here is one way, assuming your data is in cell A3:

=A3-INT(A3)

#### Jonmo1

##### MrExcel MVP
The INT function returns 0.&numbers from the right

if you want only the numbers to the right of the . try this

=MID(A3,FIND(".",A3)+1,LEN(A3)-1)

#### Domenic

##### MrExcel MVP

Try...

=C5-TRUNC(C5)

...which will return digits to the right of the decimal point, regardless of whether the number is positive or negative.

Hope this helps!

#### RalphA

##### Well-known Member
Domenic has the best solution, as he included negative numbers!

#### Cberry

##### Board Regular

I'd just use text to columns with the decimal as the delimiter.

#### daniels012

##### Well-known Member
Thank You to ALL of you!!!!! Wow!

Actually,
I need the decimal also like:
.083452156
So I can use this in another formula.

Michael

#### Domenic

##### MrExcel MVP
Actually,
I need the decimal also like:
.083452156
So I can use this in another formula.

I'm not sure what you mean. Can you elaborate?

Not 0.17 but .17
Michael

Replies
5
Views
125
Replies
9
Views
96
Replies
11
Views
218
Replies
4
Views
46
Replies
6
Views
67