Thread: Split a decimal number
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
JE McGimpsey JE McGimpsey is offline
external usenet poster
  
Posts: 4,624
Default Split a decimal number
One way:

Integer part: =INT(A1)
Fractional Part: =MOD(A1,1)

In article .com,
" wrote:

Does anyone know of a way to split a decimal number????
Reply With QuoteReply With Quote