Wrong import of float data from a text files

  • 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.
Thanks in advance.
 

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 2
complex number in excel 2003 sp3 3
How to change decimal separators when importing text (csv) files? 1
float: use of comma's versus dots: 12,2 or 12.2 2
importing a text file witnh european number formats 1
Wrong import values from webquerry 1
Import of text file - numbers destroyed! 2
Excel 2007 Import Text file - a bug with the decimal sign "." and 1

Top