Creating xls-Files - formation (percentage) is gone

[Julia Hermann]

Dear SPSS-users,

I'm asking for you help, maybe somebody knows the answer for my problem.

We are working with SPSS 19.0.1 and Excel 2010. With SPSS 17 I never had problems with the same operation, it occured with SPSS 19 but the support can't reconstruct the problem so I get no help there...

We are creating a lot of crosstabs and I need to export them into Excel-sheets. Of course I can use the copy-Paste-metho to do this, but sometimes there are hundrets of tabs so this is too much work. So I use an export-command in a syntax-file which works fine and which is based on the export-command you can run manually. But for both ways I get a nice excel-file with one thing missing: the formation of the percentages! Instead of showing me: 100,0% in a cell there is just a 1,0. I guess the problem is somehow linked with the language-adjustments (instead of 0.5 we use 0,5 in Germany to express decimals) but I use the same adjustments in SPSS 19 as I used in 17, I checked this already!! Also an adjustment in Excel from German to English didn't work! Further, the same problem occurs also in Excel 2007 or older, so the "mistake" might really be generated by SPSS. Does somebody now help, maybe had the same problem and solved it with an adjustment?

Thanks in advance!!

Best regards

Julia Hermann

[Albert-Jan Roskam]

Hi Julia!

What happens if you save everything using the OMS? Just follow the wizard in  in the menu.

 

Cheers!!
Albert-Jan

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
All right, but apart from the sanitation, the medicine, education, wine, public order, irrigation, roads, a fresh water system, and public health, what have the Romans ever done for us?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

---

From: Julia Hermann <[hidden email]>
To: [hidden email]
Sent: Tue, May 3, 2011 8:47:52 AM
Subject: [SPSSX-L] Creating xls-Files - formation (percentage) is gone


Dear SPSS-users,

I'm asking for you help, maybe somebody knows the answer for my problem.

We are working with SPSS 19.0.1 and Excel 2010. With SPSS 17 I never had problems with the same operation, it occured with SPSS 19 but the support can't reconstruct the problem so I get no help there...

We are creating a lot of crosstabs and I need to export them into Excel-sheets. Of course I can use the copy-Paste-metho to do this, but sometimes there are hundrets of tabs so this is too much work. So I use an export-command in a syntax-file which works fine and which is based on the export-command you can run manually. But for both ways I get a nice excel-file with one thing missing: the formation of the percentages! Instead of showing me: 100,0% in a cell there is just a 1,0. I guess the problem is somehow linked with the language-adjustments (instead of 0.5 we use 0,5 in Germany to express decimals) but I use the same adjustments in SPSS 19 as I used in 17, I checked this already!! Also an adjustment in Excel from German to English didn't work! Further, the same problem occurs also in Excel 2007 or older, so the "mistake" might really be generated by SPSS. Does somebody now help, maybe had the same problem and solved it with an adjustment?

Thanks in advance!!

Best regards

Julia Hermann

[Julia Hermann]

Hi Albert,

thanks for your help, the OMS-Command works fine. I just have to get to know it better to work with it. Interesting, that the SPSS-support didn't know this...

Have a nice day/evening :)


Am 03.05.2011 09:14, schrieb Albert-Jan Roskam:

Hi Julia!

What happens if you save everything using the OMS? Just follow the wizard in  in the menu.

 

Cheers!!
Albert-Jan

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
All right, but apart from the sanitation, the medicine, education, wine, public order, irrigation, roads, a fresh water system, and public health, what have the Romans ever done for us?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

---

From: Julia Hermann [hidden email]
To: [hidden email]
Sent: Tue, May 3, 2011 8:47:52 AM
Subject: [SPSSX-L] Creating xls-Files - formation (percentage) is gone


Dear SPSS-users,

I'm asking for you help, maybe somebody knows the answer for my problem.

We are working with SPSS 19.0.1 and Excel 2010. With SPSS 17 I never had problems with the same operation, it occured with SPSS 19 but the support can't reconstruct the problem so I get no help there...

We are creating a lot of crosstabs and I need to export them into Excel-sheets. Of course I can use the copy-Paste-metho to do this, but sometimes there are hundrets of tabs so this is too much work. So I use an export-command in a syntax-file which works fine and which is based on the export-command you can run manually. But for both ways I get a nice excel-file with one thing missing: the formation of the percentages! Instead of showing me: 100,0% in a cell there is just a 1,0. I guess the problem is somehow linked with the language-adjustments (instead of 0.5 we use 0,5 in Germany to express decimals) but I use the same adjustments in SPSS 19 as I used in 17, I checked this already!! Also an adjustment in Excel from German to English didn't work! Further, the same problem occurs also in Excel 2007 or older, so the "mistake" might really be generated by SPSS. Does somebody now help, maybe had the same problem and solved it with an adjustment?

Thanks in advance!!

Best regards

Julia Hermann