Wrong import of float data
 

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.

Wrong import of float data
 

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.

Wrong import of float data
 

Service Pack 2 resolve the bug.
Thank you.

Maurizio Bellantone


"Maurizio Bellantone" <Maurizio ha
scritto nel messaggio
...
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.