in excel the digit values are in Text format

[azazeererer]

Hello,

i work with Bo 4.2 sp7

to have a certain display format of the value, I applied the following script:

 EnNombre([CA];". ##")

when I generate this report in an excel file, the digit values are in Text format and not in Number: in excel I cannot do the sorts, additions on these values. I added the EnNumber function => but same problem

EnNombre (FormatNumber ([CA];". ##"))

Result of Sum in Excel :

how to be able to generate these values with the format that I defined and that I can manipulate them as much as number in Excel?

Thanks in advance

Regards

[ayman_salem · Accepted solution]

on the webi side:

You should use "Format Number" from the pop-up menu and not define it in the variable. (Do not use FormatNumber)

..

OR

on Excel side:

change the content cells in excel to number