>Hi,
>
>I'm populating a cell in an HTML table for the web. The target audience is a small group in Canada. A European visitor to the web site could easily misunderstand the numbers displayed. I don't have any idea how to address this problem except a label on the web page. I wonder how international web sites handle this.
>
>Thanks for your reply.
>
>Paul de Niverville
>
>>
>>
>>Whatever you use (like Transform) beware the guys (like them overhere) which like to read 1.000,25 as one-thousand ... I mean, if your app gets distributed to us strangers, you should have these dynamics in it ...
<<<<<<<<<<<<
Paul,
I wouldn't even know which country is using what format, but what we do is make it dependent on the language. So, what you address as "european" for sure isn't the differentiation; In Holland we have 1.000 for one-thousand, but in UK it's 1,000. In Germany ? France ? Belgium ? I don't know.
What I do know is that it seems legitimate to connect it to the language, and once f.e. it's English IMO it's right to interpret things correctly as a reader, the same as that the other language has to be interpreted.
Another thing is, that in the end it is all "making things too difficult" because the entering of numeric data is always done with a dot for the decimal-point; In some early days I tried things with SET POINT TO, but this gives only half (or less) of the solution. And BTW, which keyboard supports a comma on the numeric keypad ? and since this is "none", which (financial) user enters numeric data not via the numeric keypad or moves his finger away to the comma above the space-bar ?
Now looking at our own app working in "dutch" mode, it's all kinda weird, because numeric data is shown with comma for decimal point, but has to be entered with dot. Nobody complains about this and didn't even ask questions about this once (thousands of users). However, not having this right in f.e. UK, and nobody can work with the app. Mind you, most decimal stuff in our app has 3 decimals like 1,500.250 Kg or better (worse) : 1.250 Kg.
In the end my personal idea about this, is when an app has to support all different users for this matter, just use the comma for decimal point always, and let the few strangers (like us in Holland) swollow it.
Best wishes,
