View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Daniel.C[_2_] Daniel.C[_2_] is offline
external usenet poster
 
Posts: 105
Default Importing txt-file with "." (= dot) as decimal separator doesn't w

I think I read that it's a real bug. You can change the Excel decimal
symbol to ".", open your file and change it back to ",".
Regards.
Daniel

I'm running Finnish language version of Excel. I'm importing a text file to
spreadsheet with several colums. Text file contains colums separated with
space. Some colums contain decimal numbers with "." (= dot) as separator.

When opening the text file in Excel some of the decimal numbers are shown as
dates and other numbers are formatted as general (not as a decimal number).
This is the result regardless of which decimal separator I choose. (The
default in the Finnish version is "," (= comma).

Old Excel handled this situation without any problem. So now I walk to an
other computer with Excel 2000 in order to able solve the problem. - Not
nice.