View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Josh Craig Josh Craig is offline
external usenet poster
 
Posts: 40
Default leave the decimal fraction

If you're happy with it in a different cell I'd do this:

=a1-int(a1)

(where a1 contains the original number)

"Darrel" wrote:

How do I remove the integer from a number and retain the decimal fraction
portion (123.45 would yield 0.45)