View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default 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.