Number format in Excel download
SidMoJul 26 2010 — edited Jul 27 2010Hi. My application has an excel download functionality which works fine. Problem is that varchar2 fields in the download that have a numeric value get converted to number. This is still acceptable except for the numeric values that exceed 11 characters in length and are displayed with a notation(for e.g.,'1531621531624' is displayed as '1.53162E+12'). Is there any way to download these as character in excel ?
I've tried concatenating a special character to the column in the download query which, while effective, is not very pretty.
P.S. My application is built on PL/SQL and Mod PL/SQL.