View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
JudyT JudyT is offline
external usenet poster
 
Posts: 8
Default rounding in excel tables to add months

We have a table that we are adding years and months such as 5.1 is equal to 5
years and 1 month. What we want to have happend is excel to stop the
rounding and add the months like months with a base of 12 not 10. We have
tried, int, rounding, changing formats, precise formatting...and are at a
loss.

Please help in despartate need.
JudyT