Export to .csv while cell contains the text1E001 but it is NOT an exponential
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
|