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
|