Convert Number into Years & Periods
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
|