Home » Fusion Middleware & Colab Suite » Business Intelligence » report to excel ,problem number
report to excel ,problem number [message #442692] Wed, 10 February 2010 00:16 Go to next message
nontawit
Messages: 8
Registered: September 2007
Junior Member
Im trying to export citizen id number from an answers report to excel, but when it shows up in excel i get problems.
The result of this : 4292671110000073 comes up like this : 429267E+15 ...
I know the excel, right click, format cells, number , remove decimals ..but it seems to delete the last numer and gives me this result back : 42926711100000070 ( it should have been 3 at the end, but seems like excel is skipping this number and formats it to '0' instead..

Maybe there is somewhere i can tell answers how to export files with that many numbers and make it show up correct in excel ..

Re: report to excel ,problem number [message #460114 is a reply to message #442692] Wed, 09 June 2010 13:35 Go to previous message
skaundinya
Messages: 9
Registered: June 2010
Junior Member
Add some extra spaces after the data field.It solves the problem.
Previous Topic: Odbc driver returned an error
Next Topic: Logical Table Source
Goto Forum:
  


Current Time: Fri Mar 29 06:28:42 CDT 2024