I've been using SPSS for about a year now for work, not every day, but a few times a week, sometimes more. I usually import data from an excel spreadsheet, but recently noticed some funny behaviour with importing the decimal places.
First, it wasn't importing any of them. It would just round the numbers up or down and import that. A quick google search pointed me to a fix there.
Second, it stopped reading my top line in excel as the variable name. Restarted the program and it worked fine.
Now, I am having some decimal places import while others round up or down. I have verified that each number is formatted exactly the same in excel, and my syntax for the import has not changed at all. I have no idea why this is happening, and would really appreciate any suggestion to fix this problem.
I am using SPSS v.17 on Win7, and have tried the excel file in .xls and .xlsx (.xls works better, as I'm sure many of you know). Unfortunately I can't upload the syntax or the dataset because the data is confidential in nature.