Excel 2007 - Importing Text Decimal Separator Issue

[Nikolaj]

Hi,

I am using Excel 2007 on Vista Ultimate.

Importing a text file (txt and/or CSV) using "Data\Get external data\From
text" and changing decimal separator to point (from comma) in advanced
settings gives me an issue, namely that the applications keeps changing the
separator back to comma (being my system setting).

This is only an issue that I have experienced with Excel 2007.

I have tried making makro using (VBA) DecimalSeparator and that only solves
the issue for txt files NOT for CSV files. Apparently Excel handles the files
differently depending on extension, even though the code remains exactly the
same.

Please help me!

Thanks!

 

[Niek Otten]

Hi Nikolaj,

If you rename the .csv fie to a .txt file before opening, Excel will, on opening that file, start a dialog in which you can
specify separators, formats, etc

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| Hi,
|
| I am using Excel 2007 on Vista Ultimate.
|
| Importing a text file (txt and/or CSV) using "Data\Get external data\From
| text" and changing decimal separator to point (from comma) in advanced
| settings gives me an issue, namely that the applications keeps changing the
| separator back to comma (being my system setting).
|
| This is only an issue that I have experienced with Excel 2007.
|
| I have tried making makro using (VBA) DecimalSeparator and that only solves
| the issue for txt files NOT for CSV files. Apparently Excel handles the files
| differently depending on extension, even though the code remains exactly the
| same.
|
| Please help me!
|
| Thanks!

 

[Nikolaj]

Hi,

Thanks for your reply. Sorry I forgot to tell that this is unfortnuately not
a option. I have to distribute this Excel sheet to a number of people - and
they are receiving the text file from another application and in CSV format.
Therefore it would be á hassle to chose that path.

Please let me know if there are other ways to procceed.

Nikolaj