Solved

export to csv: long numbers automatically converted into scientific notation

Posted on 2011-02-24
2
2,732 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

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

Suggested Solutions

Introduction This article shows how to use the open source plupload control to upload multiple images. The images are resized on the client side before uploading and the upload is done in chunks. Background I had to provide a way for user…
This article aims to explain the working of CircularLogArchiver. This tool was designed to solve the buildup of log file in cases where systems do not support circular logging or where circular logging is not enabled
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

756 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