Forum Stats

  • 3,839,864 Users
  • 2,262,546 Discussions
  • 7,901,086 Comments

Discussions

When i export data into excel the bigger numbers would automatically get changed to scientific notat

User_8F96B
User_8F96B Member Posts: 17 Blue Ribbon

Hi All,

When I download the data in excel using IRR or export to excel links on classic reports, the bigger numbers would automatically get changed to scientific notation.

For Ex: 1007060000000019 is convierting in excle like 1.01031E+15.

I want to convert that excel column just to see the long numbers. I need to convert it before exporting.

Here column datatype is NUMBER.

Oracle Apex Version: 4.2.5

DB Version: 11g

Please help if any one know solution for this.

Thank You.

This discussion has been closed.