View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Pmxgs[_2_] Pmxgs[_2_] is offline
external usenet poster
 
Posts: 1
Default Text to Columns in Excel 2007

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