Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Importing HTML - Thousend seperator - Excel 2010 64bit.

Posted on 2011-03-14
4
Medium Priority
?
838 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying 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

This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
With its various features, Office 365 can not only help you with your day-to-day business tasks, it can also do wonders for your marketing campaign.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.

610 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