converting European figures ( comma as thousand seperator) from .txt files into Excel
Posted by Gavin on February 16, 2001 2:28 AM
Does anyone know how to convert the following when importing into Excel:
European Text files are producing figures like 2.3, 3.45, 5.436 where the "." is the thousand seperator, so the actual numbers are 2300, 3450 and 5436 respectively.
The issue is that the file contains number of less than 999 so I cant just multiple the whole column by 1000.
(The report contains only whole number), so UK/US decimal places not occur.
Can anyone help me please