Perhaps because Word, PowerPoint, and Outlook are not number-processing
applications, and they don't have a specific knowledge of a decimal
separator?
--
David Biddulph

Picsou wrote:
Then why is Word, PowerPoint, Outlook writing a dot, and not a comma
like Excel ?


"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.