I think you'll find that when you save as a CSV the text will be unchanged.
Open the CSV with Notepad or another text editor and I reckon that you'll
see it OK.

The problem arises if you let Excel open the CSV file with its default
options. It will try to change the text to numbers. If you do want to open
the CSV with Excel, do it by using Excel's Data/ Import External Data, and
specfify the format of the relevant columns as being Text. Don't use File/
Open or double-clicking the CSV file. [Changing the extension from CSV to
TXT is another way to bypass Excel's defaults and to make sure that you can
specify the format as Text.]
--
David Biddulph

"Rob" wrote in message
...
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