Importing txt-file with "." (= dot) as decimal separator doesn't w

M

MarttiH

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.
 
D

Daniel.C

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
 
D

David Biddulph

Check your Windows Regional Settings (in Control Panel). See what that has
as the separator. The settings there are what governs how data is treated
when being fed *into* Excel; the "Format/ Cells" options affect only how a
number (if it has been recognised as a number, rather than text) is
*displayed*.
 

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

Decimal dot to Decimal Comma 3
Mail Merge - Thousand separator and decimals 1
decimal separator? 1
Use commas as decimal separator 2
Wrong import of float data 2
Import of text file - numbers destroyed! 2
Combobox changes the decimal commas to dots - How to prevent it? 2
Problem with Excel rounding numbers 5

Top