My application is generating some Excel sheets from values fetched from a database. Some of the Excel cells with numeric values (more than 6-7 digits) are displayed in exponential form like 5.45465E+22
. I tried formatting those cells as Number, and as Text, but still I get values in exponential form.
How, please, can we disable such format for those cells in Excel?