.csv files
 

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?

.csv files
 

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.
--
David Biddulph

"totalbiz" wrote in message
...
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?