Excel Cell Length

[ansi_11111]

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..

[Niek Otten]

When importing, rename the file to a .txt file
Then Excel will prompt you for the type of field.
Choose Text for this one: Excel's precision for numbers is limited to 15 significant digits.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"ansi_11111" <[email protected]> wrote in message
news:[email protected]...
|
| H have data (number) to be imported from a database to Excell 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...o&userid=35220
| View this thread: http://www.excelforum.com/showthread...hreadid=568618
|

[ansi_11111]

Sorry, but when exporting from the database to excel file, is it the same??

[Niek Otten]

I would think that once it is text, it will be exported as text.
I suggest you try and let us know the result

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"ansi_11111" <[email protected]> wrote in message
news:[email protected]...
|
| Sorry, but when exporting from the database to excel file, is it the
| same??
|
|
| --
| ansi_11111
| ------------------------------------------------------------------------
| ansi_11111's Profile: http://www.excelforum.com/member.php...o&userid=35220
| View this thread: http://www.excelforum.com/showthread...hreadid=568618
|