report to excel ,problem number [message #442692] |
Wed, 10 February 2010 00:16 |
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 ..
|
|
|
|