Display ONLY fraction portion of number
 

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

Precede the wildcard with a tilde

~* instead of *

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

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

Wrong post

"Peo Sjoblom" wrote:

Precede the wildcard with a tilde

~* instead of *

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

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