Text to Columns in Excel 2007

P

Pmxgs

Hi,
I'm trying to import a .txt file into excel.
My regional settings have a comma as decimal separator and dot as thousands
separator.
When I import the txt file I click on advanced, and choose dot as decimal
separator and comma as thousands separator (because the file comes with these
settings).
After that excel imports the file, but discards the choices I've made.
I tried this in excel 2003 and it works fine.
Can someone please try this in excel 2007 and tell me if it works.

thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel does not accept text format! 0
Wrong import of float data 2
Importing txt-file with "." (= dot) as decimal separator doesn't w 2
Can you format numbers in Excel 2007 status bar? 3
Decimal dot to Decimal Comma 3
Save as CSV: extra spaces around commas 2
Exporting Outlook 2007 contact list without losing groups 0
Wrong import of float data from a text files 1

Top