Export to .csv while cell contains the text1E001 but it is NOT an exponential

[Rob]

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

 

[Bob I]

Prepend them with ' (single quote).

 

[Dave Peterson]

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.

 

[Dave Peterson]

ps. If you must open the file in excel, then rename it to .txt and then use
File|Open. You'll be able to specify each field as text and excel won't convert
them to numbers.

Or you could use:
Data|Import external data|
(in xl2003 menus)

And you'll see the same wizard.

 

[Rob]

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