Assuming your numeric values are in A1:A4, in B1 put the formula =INT(A1)
and drag down to B4. In C1 put the formula =MOD(A1,1) and drag down to C4.

Tyro

"Rob" wrote in message
...
Hello,
I have a column that containts numbers, and I want to change this
into years and periods.

Example:
Column A YEARS PERIODS
20.50 20 .50
19.635 19 .635
7.853 7 .853
0.89 0 .89

How do I get the desired results?

Any information would be greatly appreciated.
Thanks!
Rob