Solved

Importing HTML - Thousend seperator - Excel 2010 64bit.

Posted on 2011-03-14
4
814 Views
Last Modified: 2012-05-11
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
0
Comment
Question by:olvir
  • 3
4 Comments
 
LVL 5

Expert Comment

by:Kendor
ID: 35131335
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
 

Author Comment

by:olvir
ID: 35136398
Hi.

This had no effect.

Here is a screenshot from this.

Regards,
Olvir
commadot.png
0
 

Accepted Solution

by:
olvir earned 0 total points
ID: 35154793
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
 

Author Closing Comment

by:olvir
ID: 35187256
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

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
Outlook Free & Paid Tools
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.

932 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now