Webi intelligence report column coming as exponential value

[Former Member]

Hi All,

I am exporting web intelligence bo 4.1 report to excel.It has a number of columns having large values which are exporting to excel coming in form of exponential 7.81278E+14 in excel ...what to do in webi -column to export all the values in number in excel.

[Former Member]

You can format Object in webi to

=FormatNumber([Number Object];"#")

# - you can leave it like that or you can replace with your own format like "###,##', etc

When you export to excel, this cell/ column will be formatted as text. Its how the Excel works with long/ bigint, so when its converted to text, at least we see the actual value.