Skip to Content
0
Mar 03, 2021 at 03:22 PM

in excel the digit values are in Text format

34 Views

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