View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
buggirl buggirl is offline
external usenet poster
 
Posts: 4
Default date format - excluding year

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