Skip to Content
0
Jul 22, 2014 at 07:13 PM

Export to Excel SAP 9.0 Issue

19 Views

Hi Experts,

For some reason exports from SAP to excel cause the format of the excel to be in Text format. As in characters don't export correctly. For example when we have special characters like apostrophe's or other special characters, the characters are spelt out instead of the actual symbol itself:

Albert's changes into Albertapos;s and AT&T converts into ATamp;T. I'm not quite sure what could be causing this but numbers are also converted into text format too so the formula's in the background do not work until we change the formatting of the cell.

Regards,

Sarith

Attachments

example.png (105.9 kB)