Formula to return decimal part of the number

[KIRAN VARMA]

Need a particuler function which can return decimal part of the given number.

For e.g. 1234.50

I only need 0.50 part of above given number. Please assist.

 

[Weaver]

Welcome to the board.

Value in A1

=Mod(A1,1)

HTH

 

[KIRAN VARMA]

Thanks for the same. In fact, I had discovered this formula only few days back, and just forgotten when it actually matter the most.