Solved

Importing HTML - Thousend seperator - Excel 2010 64bit.

Posted on 2011-03-14
4
818 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

Does Powershell have you tied up in knots?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

Question has a verified solution.

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

Microsoft Office Picture Manager was included in Office 2003, 2007, and 2010, but not in Office 2013. Users had hopes that it would be in Office 2016/Office 365, but it is not. Fortunately, the same zero-cost technique that works to install it with …
This article will show you how to use shortcut menus in the Access run-time environment.
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

823 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