Convert Number into Years & Periods

[Rob]

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

 

[joeu2004]

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.

 

[David Biddulph]

=INT(A2)
=MOD(A2,1)

 

[Tyro]

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

 

[CLR]

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

 

[mohavv]

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