View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Rob Rob is offline
external usenet poster
 
Posts: 718
Default 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