LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default 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!
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
VBA code and decimals pcor New Users to Excel 6 September 30th 06 05:34 PM
How to display weeknumber with year code Lubo Excel Worksheet Functions 2 November 8th 05 12:42 PM
Pivot table formats text data with 2 decimals Don S Excel Discussion (Misc queries) 3 October 6th 05 12:45 AM
Charting a full year without zeros Brisbane Rob Charts and Charting in Excel 3 September 24th 05 10:07 PM
Data Validation (Specific Decimals or Whole #) testes Excel Worksheet Functions 4 July 7th 05 02:14 AM


All times are GMT +1. The time now is 04:27 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"