Seems to be a known bug in Excel 2007...
The dialog box where separators are marked does not retain the changes made...

Workaround...
Import as Text then
Search and replace . with something like ^^
Search and replace , with .
Search and replace ^^ with ,

You may records a macro and run it as and when required...


"Maurizio Bellantone" wrote:

Dear Sirs,
we observe a wrong import of float data from a text file generated by a C
program via a printf("%f\t%f\n",a,b) where a and b are float var.
We use Excel 2007 Italian edition fully updated.
Float data - even if we specify dot as decimal separator and comma as
thousands separator - are wrongly imported.
For examples "6.000122" is imported as "6.000.122".
This problem don't happen with Excel 2003. If needed we can send the text
file.
Thanks in advance.