Word, PowerPoint, Outlook and all my other programs are writing what is shown
on the face of the keyboard key : a dot (.)
Why does Excel transform it into a comma ?
The customer/user of a program expects that a program writes what he is
typing.
And when the face of a key on his keyboard shows a dot (.) then he expects
to see a dot (.) appearing in his document.
Anyhow : Office 2007 is creating confusion :
- for Word, PowerPpoint, Outlook, etc : a dot on the keyboard is a dot in
the document - that is the right logic
- for Excel : a dot on the keyboard becomes a comma in the document - this
is wrong behavior whatever the reason is.

WHERE IS THE MS PHILOSOPHY THAT SAYS "What you see is what you get = WYSIWYG".
Does MS say here that Excel is an exeption on their own rules - pretty
confusing !!






"David Biddulph" wrote:

It sounds to me as if the program is behaving as it is designed to behave.
The dot on the numeric keypad is designed to be a decimal separator. Your
regional settings are to display the decimal separator as a comma, so that
is how it is displaying it.
--
David Biddulph

Picsou wrote:
Typing dots and commas from the main keyboard are OK.

I have cleared the Use System Separartor checkbox : no difference

I have edited the option Use Decimal Separator into . instead of , :
this works, Excel writes a . when I hit the dot-button.

But this is not normal : my regional settings are as follows
- the , is the decimal separator
- the . is the thousands separator
I can still not understand/accept that Excel writes a comma when I
hit a button that has a dot on it's face.




"Sheeloo" wrote:

No problem...

I should have asked this earlier... How about entering the . from
the main keyboard?

Since this is happening with Calculator also it can not be an Excel
issue. Looks like your system is interpreting . as a , which must be
a display setting which Excel is reading.

Try the following (one at a time)
1. Clear the Use System Separator check box under Office Button -
Advanced - Editing Options and use decimal separator as .


2. Change keyboard setting to ENGLISH

"Picsou" wrote:

Hi Sheeloo, thanks for our patience and for trying to help me.
I typed : This.is.a.test
In the cell I see : This,is,a,test

There is no problem when I type the same text in Word or whatever
other program.

"Sheeloo" wrote:

Sorry for not being clear with my question. I had understood your
problem.

What I want to know is this -
What do you get when you try to enter the following text
This.is.a.test (using the . on the numeric keypad) to enter this?

If . is replace by , even in this then it means that your keyboard
mapping is 'bad' at the OS level (which you say is not the case as
it does not happen elsewhere, except calculator)...

If not then it HAS to be a regional setting somewhere...
(something you already suspect). I don't think it is an Excel
issue... it has to be a regional setting at OS level which formats
the numbers...


Also can you send a sample file to me to me or post it at a site
like wikisend?


"Picsou" wrote:

No Sheeloo, everything is doing just fine exept for that one
keyboard key. It is the dot key (.) on the right side numeric pad
pf the keyboard that troubles me.
It is the key that sits between the keys 0 and enter, just
underneath the key 3.
It's face shows a dot (.) and Excel 2007 makes a comma (,) out of
it.

Is this an Excel 2007 bug ?
Excel 2003 did not have that problem.

"Sheeloo" wrote:

Does this happen even when you enter text (somethin like
A.B.C.D) ?

"Picsou" wrote:


There is one more program that does the same as Excel after all
: Calculator.