On Jan 8, 11:48*am, Rob wrote:
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?

Good way to ask your question. This should serve as a model for
others.

Years (B1): =int(A1)

Periods: =A1 - B1

Note: Periods could also be computed by =mod(A1,1). But why bother
if you already have int(A1) in B1.