Home > IT Answers > Microsoft Windows > SAP export to Excel 2007
Duscher
5 pts.
 SAP export to Excel 2007
Excel 2007, Microsoft Excel, SAP, SAP Export to Excel
when exporting a spreadsheet to excel 2007, currencies show in the wrong format (ie. 1,882,456.96 shows as 1882456:96). I've tried to format the cell but this does nothing. Also I've verified switching the regional settings but no luck there neither. Help will be trully appreciatted, Max.

Software/Hardware used:
ASKED: August 5, 2009  1:34 PM
UPDATED: February 26, 2011  12:50 PM
RELATED QUESTIONS
Answer Wiki:
Hi Max, You say you export to Excel 2007. From which program or file are you exporting? Kind regards, Duncan
Last Wiki Answer Submitted:  August 6, 2009  3:20 pm  by  MacLeod   80 pts.
All Answer Wiki Contributors:  MacLeod   80 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

I am not sure if there are parameters in SAP to export the data as numeric field. You may explore this in SAP manuals.
But if the data in Excel cell is 123:45 then you can not format it as numeric. The easiest way will be “Find and Replace” function to replace “:” with “.”. Then you can format the cells as currency or another format.
Good luck.

SbElectric
 2,510 pts.
 

hello

I have the same problem in excel 2003 it export corectly the numeric value, in excel 2007 it export with “:”, even if I replace the whole column the total some of the value became wrong, I mean the total amount is different from SAP amount in the system, how can we resolve this problem?!?!?

thank you

miky

Miky5891
 10 pts.
 

Hi,

The solution is GUI 7.20

Bye(t)

Krt

Krt
 10 pts.