A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Date problem when opening a csv without dates



 
 
Thread Tools Display Modes
  #1  
Old June 19th, 2008, 01:21 PM posted to microsoft.public.excel.misc
Mila
external usenet poster
 
Posts: 7
Default Date problem when opening a csv without dates

I have got CSV file where some values look like date but they aren't.
The value is stuff number e.g. "1.05" and I don't want convert it into "1.V"
How to disable automatic conversion when CSV is open by double click?

I use excel 2003 or 2007
Thanks

  #2  
Old June 19th, 2008, 01:31 PM posted to microsoft.public.excel.misc
Pete_UK
external usenet poster
 
Posts: 8,780
Default Date problem when opening a csv without dates

If you rename the file to .txt instead of .csv then start Excel and
use File | Open, then Excel will automatically start the Text Import
Wizard. In the 3rd panel of this you can specify which fields you want
to import as text, so that Excel will not change them - good for
preserving leading zeros as well as avoiding conversions to dates.

Hope this helps.

Pete

On Jun 19, 1:21*pm, Mila wrote:
I have got CSV file where some values look like date but they aren't.
The value is stuff number e.g. "1.05" and I don't want convert it into "1..V"
How to disable automatic conversion when CSV is open by double click?

I use excel 2003 or 2007
Thanks


  #3  
Old June 19th, 2008, 02:10 PM posted to microsoft.public.excel.misc
Mila
external usenet poster
 
Posts: 7
Default Date problem when opening a csv without dates

It is usable but ...

Does not exist other way how to disable undesirable helper?
We use the CSV because it is associated to Excel on Windows.
TXT is associated with Notepad And double click is faster than the Wizard.

Thanks
MÃ*la

Pete_UK pÃ*Å¡e:

If you rename the file to .txt instead of .csv


  #4  
Old June 19th, 2008, 02:44 PM posted to microsoft.public.excel.misc
David Biddulph
external usenet poster
 
Posts: 8,714
Default Date problem when opening a csv without dates

Agreed that double click is faster. In your case you have a choice between
fast and correct.
--
David Biddulph

"Mila" wrote in message
...
It is usable but ...

Does not exist other way how to disable undesirable helper?
We use the CSV because it is associated to Excel on Windows.
TXT is associated with Notepad And double click is faster than the Wizard.

Thanks
Míla

Pete_UK píse:

If you rename the file to .txt instead of .csv




  #5  
Old June 19th, 2008, 03:01 PM posted to microsoft.public.excel.misc
Bob I
external usenet poster
 
Posts: 10,698
Default Date problem when opening a csv without dates

Then R-click the txt file and select open with, Excel or associate TXT
with Excel.

Mila wrote:
It is usable but ...

Does not exist other way how to disable undesirable helper?
We use the CSV because it is associated to Excel on Windows.
TXT is associated with Notepad And double click is faster than the Wizard.

Thanks
MÃ*la

Pete_UK pÃ*Å¡e:


If you rename the file to .txt instead of .csv




  #6  
Old June 19th, 2008, 03:11 PM posted to microsoft.public.excel.misc
Pete_UK
external usenet poster
 
Posts: 8,780
Default Date problem when opening a csv without dates

I think if you associate TXT with Excel (I've not tried it, but I have
with other pure text files) then when you double-click it all the data
will appear in one column, so you then have to use Data | Text-to-
columns to parse it (so it's no quicker).

Pete

On Jun 19, 3:01*pm, Bob I wrote:
Then R-click the txt file and select open with, Excel or associate TXT
with Excel.



Mila wrote:
It is usable but ...


Does not exist other way how to disable undesirable helper?
We use the CSV because it is associated to Excel on Windows.
TXT is associated with Notepad And double click is faster than the Wizard.


Thanks
Míla


Pete_UK píše:


If you rename the file to .txt instead of .csv- Hide quoted text -


- Show quoted text -


  #7  
Old June 19th, 2008, 04:04 PM posted to microsoft.public.excel.misc
Bob I
external usenet poster
 
Posts: 10,698
Default Date problem when opening a csv without dates

Yep, Excel 2003 does that, maybe I'm confusing it with Excel 97 actions?
OP can ignore me.

Pete_UK wrote:

I think if you associate TXT with Excel (I've not tried it, but I have
with other pure text files) then when you double-click it all the data
will appear in one column, so you then have to use Data | Text-to-
columns to parse it (so it's no quicker).

Pete

On Jun 19, 3:01 pm, Bob I wrote:

Then R-click the txt file and select open with, Excel or associate TXT
with Excel.



Mila wrote:

It is usable but ...


Does not exist other way how to disable undesirable helper?
We use the CSV because it is associated to Excel on Windows.
TXT is associated with Notepad And double click is faster than the Wizard.


Thanks
Míla


Pete_UK píše:


If you rename the file to .txt instead of .csv- Hide quoted text -


- Show quoted text -




  #8  
Old June 19th, 2008, 04:24 PM posted to microsoft.public.excel.misc
Mila
external usenet poster
 
Posts: 7
Default Date problem when opening a csv without dates

Pete,
How to quickly select all column and define as a Text in the Text Import
Wizard.
I need see all column without any modification in Excell.

Thanks
Mila

If you rename the file to .txt instead of .csv then start Excel and
use File | Open, then Excel will automatically start the Text Import
Wizard. In the 3rd panel of this you can specify which fields you want
to import as text, so that Excel will not change them - good for
preserving leading zeros as well as avoiding conversions to dates.

Hope this helps.

Pete


On Jun 19, 1:21 pm, Mila wrote:
I have got CSV file where some values look like date but they aren't.
The value is stuff number e.g. "1.05" and I don't want convert it into "1..V"
How to disable automatic conversion when CSV is open by double click?

I use excel 2003 or 2007
Thanks




  #9  
Old June 19th, 2008, 04:37 PM posted to microsoft.public.excel.misc
Pete_UK
external usenet poster
 
Posts: 8,780
Default Date problem when opening a csv without dates

In the 3rd panel of the Wizard you can select each column in turn (it
highlights) and then select the column type from the list on the right
- it defaults to General (which is fine for numbers and "normal"
text), but you can also choose Text and Date formats (or you can
choose to skip the column). I don't think you can choose more than one
column at a time.

If you want to speed things up you can record a macro while you import
the data once so that it will have all those settings, and then re-use
the macro for subsequent imports. If you plan it carefully, you can
have the macro in a master file (which never gets changed) and this
opens the file and parses it how you would like it to be.

Hope this helps.

Pete

On Jun 19, 4:24*pm, Mila wrote:
Pete,
How to quickly select all column and define as a Text in the Text Import
Wizard.
I need see all column without any modification in Excell.

Thanks
Mila



If you rename the file to .txt instead of .csv then start Excel and
use File | Open, then Excel will automatically start the Text Import
Wizard. In the 3rd panel of this you can specify which fields you want
to import as text, so that Excel will not change them - good for
preserving leading zeros as well as avoiding conversions to dates.


Hope this helps.


Pete
On Jun 19, 1:21 pm, Mila wrote:
I have got CSV file where some values look like date but they aren't.
The value is stuff number e.g. "1.05" and I don't want convert it into "1..V"
How to disable automatic conversion when CSV is open by double click?


I use excel 2003 or 2007
Thanks- Hide quoted text -


- Show quoted text -


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 10:46 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.