In Microsoft Excel, I have a calculus result; for example 8,74.
How can I say to Excel to show me just the fractional part 0,74?
In Microsoft Excel, I have a calculus result; for example 8,74. How can I say to Excel to show me just the fractional part 0,74? 


Formula Just beware that for negative numbers, like 2.3, this will give you 0.3, not 0.3. To take care of that case, try using 


You can use MOD function with a divisor of 1, e.g. with 8,74 in A1
I'm assuming that your region requires semicolon ; as a separator 

