| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| import XML data...Is there a size limit on the import? | Excel Discussion (Misc queries) | |||
| menu float | Excel Discussion (Misc queries) | |||
| How to Start Excel in Text Import Wizard for data import | Setting up and Configuration of Excel | |||
| filted data, copy and paste a col. puts data in wrong row how fix | New Users to Excel | |||
| how do I make a heading row "float" to follow the data as I scrol. | Excel Worksheet Functions | |||
Linear Mode
