Wrong import of float data

  • Thread starter Maurizio Bellantone
  • Start date
M

Maurizio Bellantone

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.
 
S

Sheeloo

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...
 
M

Maurizio BELLANTONE

Service Pack 2 resolve the bug.
Thank you.

Maurizio Bellantone


"Maurizio Bellantone" <Maurizio (e-mail address removed)> ha
scritto nel messaggio
news:[email protected]...
 

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

Wrong import of float data from a text files 1
Import of text file - numbers destroyed! 2
Importing txt-file with "." (= dot) as decimal separator doesn't w 2
Decimal dot to Decimal Comma 3
float: use of comma's versus dots: 12,2 or 12.2 2
complex number in excel 2003 sp3 3
CSV formatted files open odly in Excel 2000 3
excel 2000 takes comma as period 4

Top