Solved

Importing HTML - Thousend seperator - Excel 2010 64bit.

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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

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 …
No matter the version of Windows you are using, you may have some problems with Windows Search running too slow or possibly not running at all. Before jumping into how you can solve this issue, just know there are many other viable alternative deskt…
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

791 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