Calculation with Excel rendred values

We have a problem with Excel rendering. The target of Excel rendering should
be, that end users could use the rendered values for further calculations.
But, independent of the format of the values, we assigned within the report,
all cells have to be converted manually after excel rendering in order to be
able to use them for calculations. Where are we wrong?We are having the same problem when exporting to Excel. We're formatting our
cells using the following: #,##0.00;(#,##0.00)
The reason for this format is to show the numbers without the currency
symbol. Unfortunately, when we use this format Excel interprets it as text
instead of a specific number format. Like you, we have to manually convert
the cells to numbered formats to use them for calculations.
"Niklas" wrote:
> We have a problem with Excel rendering. The target of Excel rendering should
> be, that end users could use the rendered values for further calculations.
> But, independent of the format of the values, we assigned within the report,
> all cells have to be converted manually after excel rendering in order to be
> able to use them for calculations. Where are we wrong?