How do you re-code data? Age with decimals into age by full year
Hi, I have a data set in which age in years was calcluated from subtracting
"today's date" from the birthdate. The resulting age includes digits below decimal points. I want to re-code or format the data so the age would be in integers, but it will always be rounded down -- for example, 5.8 years will be recoded as 5 years, as well as 5.2 years. What is an easy way to do this for all cases in the data set? I want this to not only display as integers, but also be read as integers, so original 5.2 and 5.8s will be read as same numbers (so I can sort by age, and then sort by another variable within age). Thank you! |
How do you re-code data? Age with decimals into age by full year
=INT(your_formula)
or =ROUNDDOWN(your_formula,0) -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "headachewithExcel" wrote in message ... Hi, I have a data set in which age in years was calcluated from subtracting "today's date" from the birthdate. The resulting age includes digits below decimal points. I want to re-code or format the data so the age would be in integers, but it will always be rounded down -- for example, 5.8 years will be recoded as 5 years, as well as 5.2 years. What is an easy way to do this for all cases in the data set? I want this to not only display as integers, but also be read as integers, so original 5.2 and 5.8s will be read as same numbers (so I can sort by age, and then sort by another variable within age). Thank you! |
All times are GMT +1. The time now is 01:13 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com