Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Cell Length
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Cell Length
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" wrote in message ... | | 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 | |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Cell Length
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Cell Length
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" wrote in message ... | | 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 | |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
missing cell borders in Excel | Excel Discussion (Misc queries) | |||
Automatically Changing Cell Reference's when Pasting in Excel | Excel Discussion (Misc queries) | |||
I want to use a formula in excel to highlight a cell 30 days prio | Excel Worksheet Functions | |||
Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
Paste rows of numbers from Word into single Excel cell | Excel Discussion (Misc queries) |