|
dot on numeric keyboard pad is replaced by comma
Hi,
I have the followin question : In Excel 2007, the dot on numeric keyboard pad is replaced by a comma. This happens only in Excel 2007, not in Word 2007 nor in Outlook 2007. In all my other software the dot remains a dot as well. The inversion only happens in Excel 2007. Any solution ? |
dot on numeric keyboard pad is replaced by comma
Verify you have the correct Regional & International settings.
-- Gary''s Student - gsnu200830 "Picsou" wrote: Hi, I have the followin question : In Excel 2007, the dot on numeric keyboard pad is replaced by a comma. This happens only in Excel 2007, not in Word 2007 nor in Outlook 2007. In all my other software the dot remains a dot as well. The inversion only happens in Excel 2007. Any solution ? |
dot on numeric keyboard pad is replaced by comma
I verified that Gary, my settings are correct.
It is funny that ONLY Excel 2007 replaces that dot by a comma. I had Office 2003 before and Excel 2003 treated that dot correctly as well. "Gary''s Student" wrote: Verify you have the correct Regional & International settings. -- Gary''s Student - gsnu200830 "Picsou" wrote: Hi, I have the followin question : In Excel 2007, the dot on numeric keyboard pad is replaced by a comma. This happens only in Excel 2007, not in Word 2007 nor in Outlook 2007. In all my other software the dot remains a dot as well. The inversion only happens in Excel 2007. Any solution ? |
dot on numeric keyboard pad is replaced by comma
You cannot blame XL2007. The 'dot' on my numeric keypads (three machines)
give me dots (aka Anglo-Saxon decimal points) Would you please try a new keyboard and tell us what happens? best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Picsou" wrote in message ... I verified that Gary, my settings are correct. It is funny that ONLY Excel 2007 replaces that dot by a comma. I had Office 2003 before and Excel 2003 treated that dot correctly as well. "Gary''s Student" wrote: Verify you have the correct Regional & International settings. -- Gary''s Student - gsnu200830 "Picsou" wrote: Hi, I have the followin question : In Excel 2007, the dot on numeric keyboard pad is replaced by a comma. This happens only in Excel 2007, not in Word 2007 nor in Outlook 2007. In all my other software the dot remains a dot as well. The inversion only happens in Excel 2007. Any solution ? |
dot on numeric keyboard pad is replaced by comma
Hi
I use two different language keyboard (CAN French &CAN English ) in Control Panel under Regional and Language settings, I have both of then selected and can change one to the other on the fly on my Toolbar. But sometime I can be typing in Windows Mail or even in Excel and the language keyboard changes. I have to close the application and reopen it. Are you using more then one language keyboard? HTH John "Picsou" wrote in message ... I verified that Gary, my settings are correct. It is funny that ONLY Excel 2007 replaces that dot by a comma. I had Office 2003 before and Excel 2003 treated that dot correctly as well. "Gary''s Student" wrote: Verify you have the correct Regional & International settings. -- Gary''s Student - gsnu200830 "Picsou" wrote: Hi, I have the followin question : In Excel 2007, the dot on numeric keyboard pad is replaced by a comma. This happens only in Excel 2007, not in Word 2007 nor in Outlook 2007. In all my other software the dot remains a dot as well. The inversion only happens in Excel 2007. Any solution ? |
dot on numeric keyboard pad is replaced by comma
Hi Bernard,
I've done that (a Microsoft keyboard and a DELL keyboard). The result is the same : the dot-key is translated by Excel 2007 in a comma. Please note that ONLY Excel is doing this. Word, Powerpoint, Outlook, Notepad, etc are doing just fine : a dot remains a dot for them. "Bernard Liengme" wrote: You cannot blame XL2007. The 'dot' on my numeric keypads (three machines) give me dots (aka Anglo-Saxon decimal points) Would you please try a new keyboard and tell us what happens? best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Picsou" wrote in message ... I verified that Gary, my settings are correct. It is funny that ONLY Excel 2007 replaces that dot by a comma. I had Office 2003 before and Excel 2003 treated that dot correctly as well. "Gary''s Student" wrote: Verify you have the correct Regional & International settings. -- Gary''s Student - gsnu200830 "Picsou" wrote: Hi, I have the followin question : In Excel 2007, the dot on numeric keyboard pad is replaced by a comma. This happens only in Excel 2007, not in Word 2007 nor in Outlook 2007. In all my other software the dot remains a dot as well. The inversion only happens in Excel 2007. Any solution ? |
dot on numeric keyboard pad is replaced by comma
Office ButtonExcel OptionsAdvanced.
Make sure "Use System Separators" is checked. Gord Dibben MS Excel MVP On Sat, 31 Jan 2009 07:30:01 -0800, Picsou wrote: Hi, I have the followin question : In Excel 2007, the dot on numeric keyboard pad is replaced by a comma. This happens only in Excel 2007, not in Word 2007 nor in Outlook 2007. In all my other software the dot remains a dot as well. The inversion only happens in Excel 2007. Any solution ? |
dot on numeric keyboard pad is replaced by comma
No I do not John, my keybord is set to French because I have a french AZERTY
keyboard. I have only this keyboard set under Regional and Language settings. But once again : Only Excel is doing this to the poor dot key. All my other applications are behaving correctly. I rather tend to look for a solution within Excel - or am I wrong ? "John" wrote: Hi I use two different language keyboard (CAN French &CAN English ) in Control Panel under Regional and Language settings, I have both of then selected and can change one to the other on the fly on my Toolbar. But sometime I can be typing in Windows Mail or even in Excel and the language keyboard changes. I have to close the application and reopen it. Are you using more then one language keyboard? HTH John "Picsou" wrote in message ... I verified that Gary, my settings are correct. It is funny that ONLY Excel 2007 replaces that dot by a comma. I had Office 2003 before and Excel 2003 treated that dot correctly as well. "Gary''s Student" wrote: Verify you have the correct Regional & International settings. -- Gary''s Student - gsnu200830 "Picsou" wrote: Hi, I have the followin question : In Excel 2007, the dot on numeric keyboard pad is replaced by a comma. This happens only in Excel 2007, not in Word 2007 nor in Outlook 2007. In all my other software the dot remains a dot as well. The inversion only happens in Excel 2007. Any solution ? |
dot on numeric keyboard pad is replaced by comma
This setting is correctly set as well Gord.
The key shows a DOT (.) on it's surface. All my programs except for Excel show a dot (.) when I enter it. Only Excel decides to make (,) a comma out of it instead. "Gord Dibben" wrote: Office ButtonExcel OptionsAdvanced. Make sure "Use System Separators" is checked. Gord Dibben MS Excel MVP On Sat, 31 Jan 2009 07:30:01 -0800, Picsou wrote: Hi, I have the followin question : In Excel 2007, the dot on numeric keyboard pad is replaced by a comma. This happens only in Excel 2007, not in Word 2007 nor in Outlook 2007. In all my other software the dot remains a dot as well. The inversion only happens in Excel 2007. Any solution ? |
dot on numeric keyboard pad is replaced by comma
There is one more program that does the same as Excel after all : Calculator. |
dot on numeric keyboard pad is replaced by comma
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. |
dot on numeric keyboard pad is replaced by comma
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. |
dot on numeric keyboard pad is replaced by comma
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. |
dot on numeric keyboard pad is replaced by comma
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. |
dot on numeric keyboard pad is replaced by comma
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. |
dot on numeric keyboard pad is replaced by comma
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. |
dot on numeric keyboard pad is replaced by comma
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. |
dot on numeric keyboard pad is replaced by comma
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. |
dot on numeric keyboard pad is replaced by comma
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. |
dot on numeric keyboard pad is replaced by comma
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. |
dot on numeric keyboard pad is replaced by comma
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" wrote: 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. |
dot on numeric keyboard pad is replaced by comma
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. -- David Biddulph Picsou wrote: 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" wrote: 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. |
dot on numeric keyboard pad is replaced by comma
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 :-)) "David Biddulph" wrote: 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. -- David Biddulph Picsou wrote: 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" wrote: 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. |
dot on numeric keyboard pad is replaced by comma
This will happen on systems where the Decimal Separator character is
defined as a "," AND the application honors this setting. Picsou wrote: Hi, I have the followin question : In Excel 2007, the dot on numeric keyboard pad is replaced by a comma. This happens only in Excel 2007, not in Word 2007 nor in Outlook 2007. In all my other software the dot remains a dot as well. The inversion only happens in Excel 2007. Any solution ? |
dot on numeric keyboard pad is replaced by comma
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" wrote: This will happen on systems where the Decimal Separator character is defined as a "," AND the application honors this setting. Picsou wrote: Hi, I have the followin question : In Excel 2007, the dot on numeric keyboard pad is replaced by a comma. This happens only in Excel 2007, not in Word 2007 nor in Outlook 2007. In all my other software the dot remains a dot as well. The inversion only happens in Excel 2007. Any solution ? |
dot on numeric keyboard pad is replaced by comma
Sorry, I guess you will need a French keyboard that has a comma there
instead. Picsou wrote: 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" wrote: This will happen on systems where the Decimal Separator character is defined as a "," AND the application honors this setting. Picsou wrote: Hi, I have the followin question : In Excel 2007, the dot on numeric keyboard pad is replaced by a comma. This happens only in Excel 2007, not in Word 2007 nor in Outlook 2007. In all my other software the dot remains a dot as well. The inversion only happens in Excel 2007. Any solution ? |
dot on numeric keyboard pad is replaced by comma
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 On Mon, 2 Feb 2009 09:57:03 -0800, Picsou wrote: I did not have this problem in MS-Office-2003 |
dot on numeric keyboard pad is replaced by comma
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. "Bob I" wrote: Sorry, I guess you will need a French keyboard that has a comma there instead. Picsou wrote: 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" wrote: This will happen on systems where the Decimal Separator character is defined as a "," AND the application honors this setting. Picsou wrote: Hi, I have the followin question : In Excel 2007, the dot on numeric keyboard pad is replaced by a comma. This happens only in Excel 2007, not in Word 2007 nor in Outlook 2007. In all my other software the dot remains a dot as well. The inversion only happens in Excel 2007. Any solution ? |
dot on numeric keyboard pad is replaced by comma
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. "Gord Dibben" wrote: 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 On Mon, 2 Feb 2009 09:57:03 -0800, Picsou wrote: I did not have this problem in MS-Office-2003 |
dot on numeric keyboard pad is replaced by comma
And what do you get in Word or PowerPoint when you hit that same key ?
"Gord Dibben" wrote: 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 On Mon, 2 Feb 2009 09:57:03 -0800, Picsou wrote: I did not have this problem in MS-Office-2003 |
dot on numeric keyboard pad is replaced by comma
In Word I get a "dot"
Gord On Mon, 2 Feb 2009 11:04:01 -0800, Picsou wrote: And what do you get in Word or PowerPoint when you hit that same key ? "Gord Dibben" wrote: 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 On Mon, 2 Feb 2009 09:57:03 -0800, Picsou wrote: I did not have this problem in MS-Office-2003 |
dot on numeric keyboard pad is replaced by comma
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 "Gord Dibben" wrote: In Word I get a "dot" Gord On Mon, 2 Feb 2009 11:04:01 -0800, Picsou wrote: And what do you get in Word or PowerPoint when you hit that same key ? "Gord Dibben" wrote: 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 On Mon, 2 Feb 2009 09:57:03 -0800, Picsou wrote: I did not have this problem in MS-Office-2003 |
dot on numeric keyboard pad is replaced by comma
Very interesting what a search turns up.
http://www.google.com/search?hl=en&q...earch&aq=f&oq= Picsou wrote: 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 "Gord Dibben" wrote: In Word I get a "dot" Gord On Mon, 2 Feb 2009 11:04:01 -0800, Picsou wrote: And what do you get in Word or PowerPoint when you hit that same key ? "Gord Dibben" wrote: 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 On Mon, 2 Feb 2009 09:57:03 -0800, Picsou wrote: I did not have this problem in MS-Office-2003 |
| All times are GMT +1. The time now is 08:12 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com