SAP export to Excel 2007

5 pts.
Tags:
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 truly appreciated, Max.

Answer Wiki

Thanks. We'll let you know when a new response is added.

Hi Max,

You say you export to Excel 2007. From which program or file are you exporting?

Kind regards,

Duncan

Discuss This Question: 3  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • SbElectric
    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.
    2,540 pointsBadges:
    report
  • Miky5891
    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
    10 pointsBadges:
    report
  • Krt
    Hi, The solution is GUI 7.20 Bye(t) Krt
    10 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following