Thread: Export to .csv while cell contains the text1E001 but it is NOT an exponential
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob I Bob I is offline
external usenet poster
  
Posts: 2,819
Default Export to .csv while cell contains the text1E001 but it is NOTan exponential
Prepend them with ' (single quote).

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








Reply With QuoteReply With Quote