On Jan 9, 8:48*am, 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

If you want the point in the periods column you could try, but it will
be text

Column B: =INT(A2)
Column C: =RIGHT(A2,LEN(A2)-SEARCH(".",A2)+1)

Cheers,

Harold