| 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. |
| 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) | |||
Threaded Mode
