.csv files

T

totalbiz

I have a .csv file created from Excel. In one of the fields the value is in
scientific notation (for example 2.20511E+11) for each value. When I load
the .csv file in Excel and highlight any of the values the correct number
comes up on the formula bar. I have to read the .csv file provided in
another program and use the values. My question is how do I translate a
value such as 2.20511E+11 into the actual number?
 
D

David Biddulph

Format the cells as you want to see them, perhaps as number with no decimal
places, and then save as CSV. The CSV will be as you see it in the Excel
file (and you can check by reading the CSV with something like Notepad).
Don't worry that if you open the file with Excel it will possibly
reinterpret the numbers, the file will be text in the format that you wrote
it.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel CSV Files; Creating Of 3
Adding data to MS Access from csv file 0
CSV->Excel Data Problem 1
Excel And Notepad 3
CSV to Excel 4
How do I stop Excel 2007 from using scientific notation? 2
How to Write EXCEL files from a FORTRAN Program ? 0
Reading CSV with numbers in text format, Excel automatically convertsto scientific notation 1

Top