1.23 return to 0.23

[swwong]

Hello

I input 1.23 in A1
but I want B1 to return to 0.23

How can I do that?

Thanks!

 

[wa284sj]

enter in B1

=A1-1

Stuar

 

[swwong]

I mean 1.23 return to 0.23 or 2.12 return to 0.12. or 10000.1 return to
0.1


Thanks

 

[Bryan Hessey]

In B1

=a1-int(a1

 

[Peo Sjoblom]

=MOD(A1,1)

--
Regards,

Peo Sjoblom

(No private emails please)

 

[Bryan Hessey]

plus, if you wish to allow for negative numbers:

=IF(A1<0,A1+(INT(A1)*-1)-1,A1-INT(A1))

or

=IF(A1<0,MOD(A1,-1),MOD(A1,1))