Thread: leave the decimal fraction
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ardus Petus Ardus Petus is offline
external usenet poster
  
Posts: 718
Default leave the decimal fraction
=MOD(A1,1)

HTH
--
AP

"Darrel" a écrit dans le message de news:
...
How do I remove the integer from a number and retain the decimal fraction
portion (123.45 would yield 0.45)


Reply With QuoteReply With Quote