Thread: Display Part of the cell value
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Rosenfeld
 
Posts: n/a
Default Display Part of the cell value
On Wed, 16 Nov 2005 12:16:27 -0000, "Bob Phillips"
wrote:

D1: =INT(C1)
E1: =MOD(C1,1) or =C1-D1


Only for positive numbers, though.


--ron
Reply With QuoteReply With Quote