Importing HTML - Thousend seperator - Excel 2010 64bit.

Hi all.

System:
Windows 7 64bit
Office 2010 64 bit
Navision 5.01.

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.

Kind Regards,
Olvir Styrr Sveinsson
olvirAsked:
Who is Participating?
 
olvirConnect With a Mentor Author Commented:
Hi all.

I finally made a case with Microsoft. This was a known bug.

Quote from MS Tech Support:  "I have found a known issue HTML files that contain integer values and are opened in Excel 2010: a period in the integer value is replaced by a comma. This issue occurs when all the following conditions are true: The integer value is between 1,000 and 999,999."

This obviously does not apply to countries which use a , for a thousand separator.

A KB article: http://support.microsoft.com/kb/2405840/

Name of files:
office2010-kb2405840-fullfile-x64-glb.exe
office2010-kb2405840-fullfile-x86-glb.exe

Hope this helps someone.

Kind Regards,
Olvir Sveinsson

0
 
KendorCommented:
you might have to change some of the office internal options in office 2010.
have a look at the following microsoft help page:
http://office.microsoft.com/en-us/excel-help/change-the-character-used-to-separate-thousands-or-decimals-HP001230245.aspx
0
 
olvirAuthor Commented:
Hi.

This had no effect.

Here is a screenshot from this.

Regards,
Olvir
commadot.png
0
 
olvirAuthor Commented:
Microsoft Support closed this matter for me, this was a known bug. There is a patch but it is not distributed with Windows update.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.