Thread: Split a decimal number
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
merjet merjet is offline
external usenet poster
  
Posts: 812
Default Split a decimal number
Suppose cell A1 contains a number.

Then =INT(A1) gives the integer part, and =A1-INT(A1) gives the
fraction part.

Hth,
Merjet


Reply With QuoteReply With Quote