It can be done either with the Data TectToColumns feature, or with
formulas.....
=INT(A1) will give those digits to the left of the decimal point, and
=A1-INT(A1) will return the digits to the right, and the decimal point.


Vaya con Dios
Chuck, CABGx3


"Rob" wrote:

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