I think that you will find it is actually returning the number. Select the cell in the spreadsheet and look at the value in the formula bar. That should have the digits in it. The issue is that the default display for a large number is as an exponential format but the display is not what is actually stored. Try, as a counter test, writing a (say) 15 digit number in a cell and then move to another cell then look at what the cell you wrote into has as its displayed value. Update: You can 'see' longer numbers in non-exponential format. Right click the cell(s), select Format Cells, Number tab / Category Number, set Decimal places to 0.

Maybe with some code we can see whats wrong. anyway: listitem and string are not the same type. listitem.text may help. Jan

Export as CSV. It was only in wine that he laid down no limit for himself, but he did not allow himself to be confused by it. ― Confucian Analects: Rules of Confucius about his food

Please google: "excel maximum cell text length" My advice is free, and you may get what you paid for.

Member 14583542 wrote: So What Can I do? You could start by providing a proper detailed explanation of the problem. We cannot see your screen or read your hard drive.

Do what the message tells you.

You're going to need to check the documentation on the device API to find out if that's possible. I would suggest that you also contact the manufacturer; they may have different firmware builds that do what you want, even if it's not normally possible with the mass-production build. "Never attribute to malice that which can be explained by stupidity." - Hanlon's Razor

The benefit of asking "clear questions" is that you might get an "answer", instead of another "question" asking you to clarify your question. You must have a lot of time on your hands to be able to deal with just more questions (and no answers). It was only in wine that he laid down no limit for himself, but he did not allow himself to be confused by it. ― Confucian Analects: Rules of Confucius about his food

Use your own data to ru the timings.

A datatable isn't a grid; fastest load/display is with a virtualized datagridview. Examples can be found on MSDN. Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^] "If you just follow the bacon Eddy, wherever it leads you, then you won't have to think about politics." -- Some Bell.

How to get an answer to your question - Silverlight / WPF Discussion Boards[^]. Also note this is the Silverlight/WPF forum, not Visual Basic.

The question is ridiculous, why are you even considering presenting 5000 record to the user. Never underestimate the power of human stupidity - RAH I'm old. I know stuff - JSOP

Have some DDG Foo How to Create auto complete textbox in wpf with ado.net at DuckDuckGo[^] You should be doing some basic research before asking a question. Never underestimate the power of human stupidity - RAH I'm old. I know stuff - JSOP

Please read How to get an answer to your question - Silverlight / WPF Discussion Boards[^]

Requires multi-select enabled in the data grid and one delete command per selected record. The Master said, 'Am I indeed possessed of knowledge? I am not knowing. But if a mean person, who appears quite empty-like, ask anything of me, I set it forth from one end to the other, and exhaust it.' ― Confucian Analects