Solved

export to csv: long numbers automatically converted into scientific notation

Posted on 2011-02-24
2
2,661 Views
Last Modified: 2012-05-11
Hi,

I am export a datatable from asp.net page to csv file. One column in datatable is long number. But in the exported csv, it is always displayed as scientific notation. How can i enforce it to be displayed as normal number?

thx
0
Comment
Question by:viola123
2 Comments
 
LVL 14

Accepted Solution

by:
quizwedge earned 500 total points
ID: 34975664
Try looking at the second to last comment at http://www.telerik.com/community/forums/aspnet-ajax/grid/export-to-excel-prventing-long-numbers-from-scientific-notation.aspx

Alternatively, you can put an apostrophe before the numbers, which would convert it to text and prevent it from being displayed as scientific notation.
0
 
LVL 11

Expert Comment

by:Sudhakar Pulivarthi
ID: 34978220
0

Featured Post

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

ASP.Net to Oracle Connectivity Recently I had to develop an ASP.NET application connecting to an Oracle database.As I am doing it first time ,I had to solve several problems. This article will help to such developers  to develop an ASP.NET client…
A quick way to get a menu to work on our website, is using the Menu control and assign it to a web.sitemap using SiteMapDataSource. Example of web.sitemap file: (CODE) Sample code to add to the page menu: (CODE) Running the application, we wi…
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…
Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…

813 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now