View Single Post
  #5   Report Post  
Ken Macksey
 
Posts: n/a
Default

Hi

assuming the data is in cell c3, you could do something like

=MOD(C3,1)

And then do what you want with it like multiply it by 1000 etc

=(MOD(c3,1)) * 1000

HTH

Ken