Home |
Search |
Today's Posts |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Are you sure that in the wizard settings you haven't got the dot as your
thousands separator too? If you do, you'll get the symptoms you describe. Your thousands separator shouldn't be the same as your decimal separator. -- David Biddulph wrote in message ... Ok, I have a clue. If I manually replace the decimal separators in a text editor (with the comma, as per locale settings), Excel can suddenly import the file just fine. It looks as if the decimal separator setting in the "Advanced" section of the import dialog is simply ignored. Robert |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Set Defaults in File Import of a Text File | Excel Worksheet Functions | |||
Import only certain rows from text file | Excel Discussion (Misc queries) | |||
import from text file | Excel Discussion (Misc queries) | |||
Would Like to Automate Batch File Creation and Text FIle Import | Excel Discussion (Misc queries) | |||
How To Import Text File With No Delimiters? | Excel Discussion (Misc queries) |