Skip to Content
0
Former Member
Dec 07, 2006 at 02:31 PM

Export query from WEB BEx to Excel: key figures -> text fields

88 Views

Hello Guru's,

I ran a query using Webreporting (NW 2004s). I then exported the queryresult to Excel using export to Excel button. Every field (key-figures) in the report with a unit of measure ( i.e. EUR, USD) becomes a text field (instead of number what is expected).

The only option that I have seen is doing the process manually of changing the fields back to the original format.

Is the way of retaining the field format when you export to excel?

Thanks in advance.

René