Posted to microsoft.public.excel.misc

Rob[_5_]

external usenet poster

Posts: 25

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Converting imported cell from exponential form	Katie Mac	Excel Worksheet Functions	1	February 27th 08 07:27 PM
export re-order input fields to export file [csv]	madisonpete	Excel Worksheet Functions	0	November 30th 07 03:51 PM
Exponential	escapeman	Excel Worksheet Functions	9	November 4th 07 08:28 PM
Bi-Exponential Fit	tucopup	Excel Discussion (Misc queries)	0	September 2nd 05 06:05 PM
Exponential values	Malotsha	Excel Worksheet Functions	6	August 27th 05 03:18 AM

All times are GMT +1. The time now is 09:53 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us