Lose digits to left of decimal?

[SentientParadox]

I've done this before using macros, but it's a pain in the neck. What I really need is to do this using a formula if at all possible, so I can create charts of the results.

I'm going to have columns of results, all of which will have digits to the right of decimal. I need to loose any and all digits to left of the decimals, but will be showing the results in separate columns.

Any formula exist to accomplish that?

[darkyam]

=Mod(A1,1) will get rid of all digits to the left of the decimal.

[Paul]

Another option is..

=A1-INT(A1)

[SentientParadox]

Perfect! I was always more into the Macros, and never did learn enough about formulas.

Thanks guys. Off and running!