Wrong import of float data

  • Thread starter Thread starter Maurizio Bellantone
  • Start date 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.
 
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...
 
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
Importing txt-file with "." (= dot) as decimal separator doesn't w 2
Importing data from Excel worksheet into Excel template 2
Import of text file - numbers destroyed! 2
Rounding difference in Access 2003 text exports 2
Extracting data from spreadsheet to a graph 2
Data Import Question 4
Importing text with text qualifier 2

Back
Top