Export to .csv while cell contains the text1E001 but it is NOT anexponential
Use NotePad (or your favorite text editor) to look at the file.
I bet it'll look ok.
If you open the .csv file into excel, you'll see that it's the importing that
causes the trouble.
Rob wrote:
Hello,
these figures are roomnumbers of an officebuilding.
1E001
1E010
1E011
1E013
1E016
1E017
1E023
So they are NOT exponentials.
While exporting these to a .csv file they are changed into
1,00E+01
1,00E+10
1,00E+11
1,00E+13
1,00E+16
1,00E+17
1,00E+23
I tried to write the number in text-formatted cells but even than I get the
same results.
Anyone who knows a workaraound?
Rob
--
Dave Peterson
|