Oracle Transactional Business Intelligence

Products Banner

Number columns are in text format in Excel export

Accepted answer

Hi, when our users export the data from Business Intelligence Publisher report to Excel, they want to perform additional analyses. Hence, they need to perform calculations on number columns, but the columns are in text format and when the user tags a couple of Excel cells, they only count, the average and sum are not calculated (this is a good way of checking the cell format).

There is a function in Excel (NUMBERVALUE) which can be used to convert the data into numbers, and it works, but we need more permanent solution for the users.

Best Answer