Thread
:
leave the decimal fraction
View Single Post
#
3
Posted to microsoft.public.excel.worksheet.functions
Toppers
external usenet poster
Posts: 4,339
leave the decimal fraction
A1=123.45
in B1 put:
=MOD(A1,1)
HTH
"Darrel" wrote:
How do I remove the integer from a number and retain the decimal fraction
portion (123.45 would yield 0.45)
Reply With Quote
Toppers
View Public Profile
Find all posts by Toppers