N
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!
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!