=MONTH(A1) & "'" & DAY(A1)
=MONTH(A1) & "." & DAY(A1) & " ft"
Dear everyone,
Could you please help me to convert date to height?
Date format 6/2/2000, I would like to convert it to a new cell which shows as "6'2"(or as "6.2 ft")
Date Format 5/6/2006 will show as "6.5 ft"
Thank you all so much
Cheers,
Thanks for your replying. I got a project which requires me to go http://web1.ncaa.org/stats/StatsSrv/careerteam to get the data. When copy and paste it to the Excel, it appears as date. Could you show me how to get back to the height?