View Single Post
  #4   Report Post  
Roger Knights
 
Posts: n/a
Default how to split one decimal pt integer off & to next columnin exc

Thanks - exactly what i wanted:)

Roger Knights

"Arvi Laanemets" wrote:

Hi again! Sorry, the last formula must be
=MOD(A2,1)*10^N

--
Arvi Laanemets
( My real mail address: arvil<attarkon.ee )