Excel Cell

[ansi_11111]

I have data (number) to be imported from a database to Excel workshee
the long of this number is up to 20 digits. when exporting it, the las
digits (after fifteen digits) become zeroes. For example
82000032656565612345 becomes 82000032656565600000.

Kindly confirm if there is any settings to modify the Excel cell t
accept like this number!!!

Your help is highly appreciated.

 

[Niek Otten]

Please don't post to more than one group in separate postings.
See my answer in other newsgroup

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|
| I have data (number) to be imported from a database to Excel worksheet
| the long of this number is up to 20 digits. when exporting it, the last
| digits (after fifteen digits) become zeroes. For example,
| 82000032656565612345 becomes 82000032656565600000.
|
| Kindly confirm if there is any settings to modify the Excel cell to
| accept like this number!!!
|
| Your help is highly appreciated..
|
|
| --
| ansi_11111
| ------------------------------------------------------------------------
| ansi_11111's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=35220
| View this thread: http://www.excelforum.com/showthread.php?threadid=568619
|