Prev: Inserting shapes on a diagnal plane.
Next: how to increase the maximum value of a spinner
From: totalbiz on 25 Jan 2010 16:26
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?
From: "David Biddulph" groups [at] on 25 Jan 2010 16:35
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" <totalbiz(a)discussions.microsoft.com> wrote in message
news:34CC7E04-0384-4249-9099-26C6B4176F36(a)microsoft.com...
>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?


 | 
Pages: 1
Prev: Inserting shapes on a diagnal plane.
Next: how to increase the maximum value of a spinner