1.23 return to 0.23
 

Hello

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

How can I do that? :confused:

Thanks!


--
swwong
------------------------------------------------------------------------
swwong's Profile: http://www.excelforum.com/member.php...o&userid=23963
View this thread: http://www.excelforum.com/showthread...hreadid=375861

enter in B1

=A1-1

Stuart


--
wa284sj
------------------------------------------------------------------------
wa284sj's Profile: http://www.excelforum.com/member.php...o&userid=22941
View this thread: http://www.excelforum.com/showthread...hreadid=375861

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


Thanks


--
swwong
------------------------------------------------------------------------
swwong's Profile: http://www.excelforum.com/member.php...o&userid=23963
View this thread: http://www.excelforum.com/showthread...hreadid=375861

In B1

=a1-int(a1)


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=375861

=MOD(A1,1)

--
Regards,

Peo Sjoblom

(No private emails please)


"swwong" wrote in
message ...

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


Thanks


--
swwong
------------------------------------------------------------------------
swwong's Profile:
http://www.excelforum.com/member.php...o&userid=23963
View this thread: http://www.excelforum.com/showthread...hreadid=375861

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))


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=375861