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

Convert Number into Years & Periods
 

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.

Convert Number into Years & Periods
 

=INT(A2)
=MOD(A2,1)
--
David Biddulph

"Rob" wrote in message
...
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

Convert Number into Years & Periods
 

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

"Rob" wrote in message
...
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

Convert Number into Years & Periods
 

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

Convert Number into Years & Periods
 

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