how i can display 20 digit number in excel file , from oracle forms
437329May 5 2008 — edited Aug 5 2009to all,
i created a oracle form to create csv> excel file.
all data is displaying fine . But excel don't support 15+ digits numbers
ex:- 11111222223333344444 is displayed as 1.11111E+19 or something like this .
it cause because excel won't support 15+ digit numbers.
the solution is i have to convert my data to text in oracle form level.
i tried a cpl of ways and still in same boat.
Is anybody knows how to do it?
the data type for this filed in table is varchar2(20)
i appreciate all help.