Importing HTML - Thousend seperator - Excel 2010 64bit.
Posted on 2011-03-14
Windows 7 64bit
Office 2010 64 bit
I have a bit strange problem. I am trying to import a HTML file which has been exported in Navision. This has worked fine so far but now we are doing this on Office 2010 in Windows 7 all 64 bit. This was done on XP with Office 2007 before and worked fine.
When we import the HTML file something goes wrong with the thousand separator. I am located in Iceland so we use . (dot) for a thousand separator and , (comma) for fractions.
Excel 2010 seems to do this right except with numbers which are under 1.000.000,- (one million). Numbers under a million Excel changes the the . (dot), which is by default the thousand separator in the HTML sheet to a , (comma).
Please, ask questions if deeper clarification is needed.
Olvir Styrr Sveinsson