software

I exported a sheet to CSV, did some reordering of the rows with a perl
script and
imported it back in. fields such as 04-41 it changes to Apr-41
regardless if the
field is quoted or not. Why is it doing that and how can I make it
leave the field alone as it is ?You can rename it to *.txt and then the text import wizard will start and
you can import it as text in step 3 or you can open it though datagt;import
external datagt;import data then in filetypes select *.* then open it, it will
trigger the same text import wizard.

--

Regards,

Peo Sjoblom

nwexcelsolutions.comgt; wrote in message oups.com...
gt;
gt; I exported a sheet to CSV, did some reordering of the rows with a perl
gt; script and
gt; imported it back in. fields such as 04-41 it changes to Apr-41
gt; regardless if the
gt; field is quoted or not. Why is it doing that and how can I make it
gt; leave the field alone as it is ?
gt;
Use the import wizard, and when you reach Step 3 click in the column
containing the problem data. In the quot;Column data formatquot; area at the top
right of the dialog box, click Text. Then complete the wizard.

Hope that works for you!

--
ERR229quot; wrote:

gt;
gt; I exported a sheet to CSV, did some reordering of the rows with a perl
gt; script and when you reach Step 3, click in the column containing the problem data. Then, toward the t
gt; imported it back in. fields such as 04-41 it changes to Apr-41
gt; regardless if the
gt; field is quoted or not. Why is it doing that and how can I make it
gt; leave the field alone as it is ?
gt;
gt;