View Single Post
  #5   Report Post  
John F
 
Posts: n/a
Default

Thanks Peo: Works Great!!
John F.

"Peo Sjoblom" wrote:

Try

=MOD(A1,1)


Regards,

Peo Sjoblom

"John F" wrote:

Using Excel 97, SR2
In Lotus, could go =Frac(A1)
This would strip off everything to left of
decimal in cell A1.

Does Excel have an equivalent?
I've tried using custom number formats, but can't get
that to do what I want.

Thanks in advance.
--
John F. Scholten