Need to change dates to part of a number

[daniels012]

I copied/pasted data from a web page to a spreadsheet. When I copied data that has ie: 3-2, 2-2,1-5
it converted them to dates???? I need to take a date 3/2/2005 and convert it so it says 3-2. I need help with a formula to help me achieve this. Is this even possible??

Thank You,
Michael

 

[Norie]

Michael

Before you paste the data into Excel fomat the problem column(s) as Text.

 

[fairwinds]

Hi,

Try:

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

or

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

wich ever is correct for you.

 

[daniels012]

Thank You very much, Fairwinds!!

That worked great! I should have figured that one out though!!!!!!!


Michael