=MOD(A1,1)

will return decimal

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)



"osuhoosier" wrote in message
...
Using a IF formula, I would like to drop the 2 digits in front of the
decimal, and only use the 2 digits after the decimal