Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
.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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
.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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Navigating to Excel files over network slow, but not Word files | Excel Discussion (Misc queries) | |||
How can I batch convert 97-2003 .xls files to 2007 .xlsx files | Excel Discussion (Misc queries) | |||
Excel 2007 tmp files filling up drive with XLSM files | Excel Worksheet Functions | |||
How to change default Open/Files of Type to "Microsoft Excel Files | Excel Discussion (Misc queries) | |||
Drive Erased, got Files back but only excel files scrambled, help. | Excel Discussion (Misc queries) |