View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Scott P Scott P is offline
external usenet poster
 
Posts: 26
Default how do i get only the decimal value in excel

Thanks, Martin. Vardoo and Martin -- I would only note two things regarding
the two formulas below (1) if you use INT instead of TRUNC with negative
numbers, different results will be returned for different numbers (e.g. the
below INT formula will return 0.55 if you pass in -23.45 as the argument --
the Excel help file provides good coverage of the difference between INT and
TRUNC) and (2) the use of a multiplier to remove the decimal point from the
result can get more involved if you are not sure that the fractional part of
the number will contain two digits (e.g. 45).

I hope that helps.

"MartinW" wrote:


Hi vardoo,

=A1-INT(A1) will return 0.45

=(A1-INT(A1))*100 will return 45

HTH
Martin