Excel 2007 - Importing Text Decimal Separator Issue

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Nikolaj - 20 Dec 2007 14:05 GMT

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!

Reply to this Message

Niek Otten - 20 Dec 2007 20:34 GMT

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

Signature

Kind regards,

Niek Otten
Microsoft MVP - Excel

| Hi,
|
[quoted text clipped - 15 lines]
|
| Thanks!

Reply to this Message

Nikolaj - 21 Dec 2007 12:36 GMT

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

> Hi Nikolaj,
>
[quoted text clipped - 20 lines]
> |
> | Thanks!

Reply to this Message