Bob, David, Dave,

that's why I LOVE newsgroups. Other people have a fresh look at your
problem. I never thought of checking it out with Notepad. It worked perfect!

Thanks!

Rob


"Rob" schreef in bericht
...
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