only show decimals

[Guest]

I have a need to only show the figure to the right of a decimal point not the
whole number. Reason is to calculate the best bar length to use i.e. the
decimal bit is the size of the offcut and I need to find the optimum size.

 

[Dave Peterson]

You could use another cell:

=mod(a1,1)
or
=a1-int(a1)

 

[David Biddulph]

=MOD(A1,1)