only show decimals
 

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.

only show decimals
 

You could use another cell:

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


Steve Holbrook wrote:

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

only show decimals
 

=MOD(A1,1)
--
David Biddulph

"Steve Holbrook" <Steve wrote in message
...
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.