Arch
Married to Night Train
Help!
It's going to drive me nuts. I have data in SPSS. For various reasons, I needed to copy the SPSS sheets over to Excel to put some data from different files together. One of my SPSS variables is "Century" - ie, 12th, 15th, or, and this is the problem, in some cases a century range, ie, 12th-13th (entered as 12-13, as a string variable). The problem is, when I copy it over to excel, it's assuming 12-13 means December the 13th! (Dec-13). Clear?
I've tried right click and format cell (ie, change from date to number, or general), but whatever I do (and I'm flailing about a bit) it just returns to Dec-13 wherever I type 12-13. It's doing the same with 9-10 (Sept-10) and so on, but 15-16 is fine, I guess it can't work out a month...
What should I be doing, in terms of formating the cell? I think I must be missing something...
Also, I tried a find and replace for the Dec-13 thing, and it couldn't find any!
<bangs head on table>
It's going to drive me nuts. I have data in SPSS. For various reasons, I needed to copy the SPSS sheets over to Excel to put some data from different files together. One of my SPSS variables is "Century" - ie, 12th, 15th, or, and this is the problem, in some cases a century range, ie, 12th-13th (entered as 12-13, as a string variable). The problem is, when I copy it over to excel, it's assuming 12-13 means December the 13th! (Dec-13). Clear?
I've tried right click and format cell (ie, change from date to number, or general), but whatever I do (and I'm flailing about a bit) it just returns to Dec-13 wherever I type 12-13. It's doing the same with 9-10 (Sept-10) and so on, but 15-16 is fine, I guess it can't work out a month...
What should I be doing, in terms of formating the cell? I think I must be missing something...
Also, I tried a find and replace for the Dec-13 thing, and it couldn't find any!
<bangs head on table>