SAP Note 17778 - Downloading Consolidation data

Symptom:

The user wants to transfer consolidation data as values (and not text) to a spreadsheet program via download.

Solution
Downloading of consolidation data as valuese is supported in the following areas:

- Totals reports (RGCAUS00, list type 1 only)
- Report Writer (starting with Release 3.0)
- Executive Information System (starting with Release 2.2)

If the options 2 and 3 have not been implemented, or the totals report
and EIS do not provide enough detail, you should consider the option of
downloading the database list (RGCLST00).

This option provides a maximum of detail, however as text information
only. The database records must be processed in two ways:

- allocation into multiple columns
(wizard support in MS-EXCEL 5.0)

- Texts with minus signs ("123-") must be converted to values
(e.g.: -123). This is achieved using formulas.
In Excel, for example, you would define the cell XY as follows:

=value(if(right(XY)="-";
replace(replace(XY;search("-";XY;1);1;"");1;0;"-");XY))