Separating integer and decimal

[elsmith9035768]

I am separating the number 3.1 in cell A1 by integer and decimal. For the decimal, =MOD(A1,1) is returning “0.1” while I need to show “1” as the result.

 

[PCosta87]

I am separating the number 3.1 in cell A1 by integer and decimal. For the decimal, =MOD(A1,1) is returning “0.1” while I need to show “1” as the result.

Hi,

Please refer to attachment
B1:C1 if you use "."
B2:C2 if you use ","

Use accordingly

Hope it helps

 

[bosco_yip]

To extract decimal part as a whole number.

Try, one of :

=--MID(A1,FIND(".",A1)+1,99)

=--RIGHT(A1,LEN(A1)-FIND(".",A1))

=MOD(A1,1)*10^(LEN(A1)-FIND(".",A1))

Regards
Bosco

 

[Marc L]

Or just use Convert from Excel menu / ribbon ‼
​