Thread
:
Split a decimal figure
View Single Post
#
3
Posted to microsoft.public.excel.misc
Bernd P
external usenet poster
Posts: 806
Split a decimal figure
B1:
=INT(A1)
C1:
=MOD(A1,1)
or
=A1-B1
Regards,
Bernd
Reply With Quote
Bernd P
View Public Profile
Find all posts by Bernd P