Convert date to height

Scott Huish

MrExcel MVP

Joined

Mar 17, 2004

Messages

20,337

Office Version

1. 365

Platform

1. Windows

• Jun 27, 2007

• #2

How exactly do you get those values from those dates?

 

Upvote 0

K

kmillen

Board Regular

Joined

Jun 8, 2007

Messages

115

• Jun 27, 2007

• #3

Try this but beware.

If A1 contains the date 6/2/2000, the following returns 6'2.

Code:

=MONTH(A1) & "'" & DAY(A1)

And, the following returns 6.2 ft.

Code:

=MONTH(A1) & "." & DAY(A1) & " ft"

It should be noted that six feet, two inches is NOT equal to 6.2 ft.

 

Upvote 0

T

Teethless mama

Board Regular

Joined

Mar 31, 2007

Messages

205

• Jun 27, 2007

• #4

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,

Click to expand...

=MONTH(A1)&"'"&DAY(A1)

 

Upvote 0

H

haminh

New Member

Joined

Jun 27, 2007

Messages

13

• Jun 27, 2007

• #5

Hello,

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?
Thanks a lot

 

Upvote 0

G

Giordano Bruno

Well-known Member

Joined

Jan 7, 2007

Messages

1,341

• Jun 28, 2007

• #6

Assuming the "date" is placed in cell A1, this might get you what you want

=DAY(A1)&"'"&MONTH(A1)&""""

 

Upvote 0

G

GoBeavs777

New Member

Joined

Jun 27, 2007

Messages

3

• Jun 28, 2007

• #7

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?

Click to expand...

It might be easier to get it cleanly into Excel, rather than converting it once it gets there.

Copy from the site and paste it into MS Word.

Go to the menu, select Table, Convert, Table to Text, and tab delimit.

Save the Word document as a text file.

Open the text file with Excel, which will allow you to assign a Text format to the height column.

 

Upvote 0