APEX

I have created a report based on a sql query.

The report contains a numeric column which displays ok on the screen in the report eg: 157582455813

I have enabled CSV Output for my report.

When the CSV output opens in Excel, the numeric value displays as 1.57822E+11.

When I click into a field within the Excel sheet, I can see the actual value of the column is still 157582455813, and just requires manual formatting to be displayed correctly.

When I format the values manually using Excel the number is displayed OK, but my users shouldn't have to do that manually after downloading a file, I want the csv to open with all numbers correctly formatted.

So I tried to use the format mask option for the specific column in my sql statement, as 999999999999999, which still displays Ok to the screen, but also still displays as 1.57822E+11 when the csv is output to excel.

Other format masks (that I don't want to use, eg: 999G999G999G999G990D00), all seem to work ok displaying to the screen in htmldb, and when output as csv to excel, so I think I must be doing something wrong.

I just want this number to display as a single number, with no comas, currency symbols, decimal places et.

Any ideas where I'm going wrong? Or is this some excel/csv issue?

Thanks.