Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Importing txt-file with "." (= dot) as decimal separator doesn't w
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Importing txt-file with "." (= dot) as decimal separator doesn't w
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*. -- David Biddulph "MarttiH" wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
Lost "File Menu" - now it's "Edit / View / Insert.." but no "F | Excel Discussion (Misc queries) | |||
Avoiding "0" importing blank cells from another Excel file | Excel Discussion (Misc queries) | |||
no comma separator for ="total"&"$ "&sum(a1:a10) | Excel Worksheet Functions | |||
importing a text file - problem with dates "Americanising" | Excel Discussion (Misc queries) |