date format - excluding year
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" wrote:
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
|