date format - excluding year

[buggirl]

Hello,

I'm having trouble exporting data from Excel to SPSS. I think the problem is
with the format of dates. Excel defaults to dd-mmm-yy, but I don't want to
include year in that column (it goes in a separate column, so I can sort on
year). I keep changing the format to Short Date dd-mmm, but it doesn't seem
to be working.

Any suggestions?

Thanks,

buggirl

 

[Sheeloo]

In Excel you can not have a date without a year. If you just want date and
month then you need to enter them as text.

If you have date in A1 then
=Text(A1,"m") will give you the month
and
=Text(A1,"d") will give you the date

You can use mm, mmm, mon,dd etc as the second argument.

 

[buggirl]

That's very useful - thank you both. I'll try fooling around with the text
formula.

cheers,

buggirl