dot on numeric keyboard pad is replaced by comma

[Picsou]

A user does not have to deal with "perhaps" !
What he/she sees on his/her keyboard is what should be entered in his/her
document !

 

[David Biddulph]

If you want a document to show exactly what you type in, you want a
typewriter and probably not even a word-processor. For that purpose you
certainly ought *not* to be using a spreadsheet with its ability to adjust
the format of a display of a number to comply with the options which the
user has specified. The key you are using on the numerical keypad is
designed as a decimal separator, and Excel is displaying the decimal
separator in accordance with your options. It is behaving in the same way
as it does when you enter a date in a variety of different formats and that
date is displayed according the date format display options which have been
specified. I don't think many users would want a numeric keypad to have a
key for the thousands separator but not for the decimal separator.

If you are saying that Excel is not the tool which you should be using for
your purposes, I agree with you.

 

[Picsou]

David,

You did not bring any solution to my problem and the one of many MS-usrs who
struggle with inconsistency on this point.
You decided to blame me or to make a fool of me instead.
So please transfer yourself into a dot (.) - the smallest one possible )

 

[Bob I]

This will happen on systems where the Decimal Separator character is
defined as a "," AND the application honors this setting.

 

[Picsou]

I understand what you are trying to explain to me.

BUT :

When I see a dot on the face of one of my keyboard keys, then I expect that
the MS Office applications (Excel, Outlook, PowerPoint, Word) treat it the
same way : as a dot !

This is definetely a bug in MS-Office-2007
I did not have this problem in MS-Office-2003

 

[Bob I]

Sorry, I guess you will need a French keyboard that has a comma there
instead.

 

[Gord Dibben]

If my regional settings for decimal is a comma, I get a comma in Excel 2003
when I hit the "dot" key.

Maybe when you were running Excel 2003 your regional settings for decimal
was a "dot"?


Gord Dibben MS Excel MVP

 

[Picsou]

I have a French keyboard !

But anyhow : all of the MS-Office-2007 applications should treat the sign in
the same way - whether that is a dot or a comma.
It is MS-Office-Excel-2007 that makes an exception by inversing the dot and
the comma compared to the other applications in the "professional Office
Suite", and that is confusing, inconsistent and by consequence not acceptable.

 

[Picsou]

My regional settings have never changed !
My keyboard is still the same !
The only thing that changes is the Office version : it was 2003, and it has
become 2007.

All of the Office 2003 applications (Excel, Outlook, PowerPoint, Word) have
always followed what was on the face of that keyboard-key - and that is (and
always has been) a DOT.

Excel 2007 decided to do it differently and translates the DOT into a COMMA.

 

[Picsou]

And what do you get in Word or PowerPoint when you hit that same key ?

 

[Gord Dibben]

In Word I get a "dot"


Gord

And what do you get in Word or PowerPoint when you hit that same key ?

 

[Picsou]

I give up !

It has become clear to me that :

MS is making programs american programs for Americans !
MS couldn't care less about the "stupid" rest of the world.

I begin to understand the attitude of the European Commission versus MS.

Beye

 

[Bob I]

Very interesting what a search turns up.
http://www.google.com/search?hl=en&q=decimal+separator+character+key&btnG=Google+Search&aq=f&oq=