how do you convert dates into height?

[NewbieMan]

Hi I have cells that have been imported from the net. In the webpage there are values for heights that appear as follows "6-3" for 6 feet 3 inches, but when imported into Excel the cell reads "3-jun".

How could i copy that cell into another cell with the correct format?

So lets say I have cell A1 with the 3-jun value. I want to have in B1 that value converted into 6-3.

Anyone able to provide some help please? Thanks

 

[James006]

Hello,

You could test following:

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

HTH

 

[NewbieMan]

sorry James...let me correct something above...

the value of the cell A1 is actually showing up as 6/3/2017. I was looking at what the cell was displaying above but this is the complete value showing up in the formula bar.

 

[James006]

Hello again,

Have you tested the formula ..???

 

[NewbieMan]

sorry james - yes I just tried it and it worked great! Thanks very much for your help

 

[James006]

Glad you could fix your problem ...:wink:

Thanks for your Thanks ...