Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have a user running Excel 2007 having problems entering negative numbers
with the minus key on the numeric keypad. When he presses the minus key "Extend Selction" shows up in the status bar. He can enter negative numbers from the regular keys. Turning num lock on and off does not resolve the issue. Any ideas on how to fix this? |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
It is the F8 key that toggles EXT on and off
Is it possible the keyboard is the problem? Hope it not a laptop! best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "cphalen" wrote in message ... I have a user running Excel 2007 having problems entering negative numbers with the minus key on the numeric keypad. When he presses the minus key "Extend Selction" shows up in the status bar. He can enter negative numbers from the regular keys. Turning num lock on and off does not resolve the issue. Any ideas on how to fix this? |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Pretty sure it is not a keyboard issue. User has 3 PC's and is using synergy
software, so same keyboard across all PC's. Problem occurs on 2 of the PC's and not the other one. On my PC I can bring up the extend selection in the status bar either by using F8, or by using the minus key if I have my num lock off, I believe this is normal, however the user with the issue is having the problem wether his num lock is on or off. Could this be caused by a Macro?? "Bernard Liengme" wrote: It is the F8 key that toggles EXT on and off Is it possible the keyboard is the problem? Hope it not a laptop! best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "cphalen" wrote in message ... I have a user running Excel 2007 having problems entering negative numbers with the minus key on the numeric keypad. When he presses the minus key "Extend Selction" shows up in the status bar. He can enter negative numbers from the regular keys. Turning num lock on and off does not resolve the issue. Any ideas on how to fix this? |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I always have NumLock on. I have never seen the minus key turn EXT on! We
live and learn! I still suspect the keyboard - why not experiment? As for macro, try starting Excel in save mode -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "cphalen" wrote in message ... Pretty sure it is not a keyboard issue. User has 3 PC's and is using synergy software, so same keyboard across all PC's. Problem occurs on 2 of the PC's and not the other one. On my PC I can bring up the extend selection in the status bar either by using F8, or by using the minus key if I have my num lock off, I believe this is normal, however the user with the issue is having the problem wether his num lock is on or off. Could this be caused by a Macro?? "Bernard Liengme" wrote: It is the F8 key that toggles EXT on and off Is it possible the keyboard is the problem? Hope it not a laptop! best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "cphalen" wrote in message ... I have a user running Excel 2007 having problems entering negative numbers with the minus key on the numeric keypad. When he presses the minus key "Extend Selction" shows up in the status bar. He can enter negative numbers from the regular keys. Turning num lock on and off does not resolve the issue. Any ideas on how to fix this? |
#5
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Trun off your num lock key while in excel and then enter a minus key in a
cell using the number key pad and see if EXT shows up in the status bar please. "Bernard Liengme" wrote: I always have NumLock on. I have never seen the minus key turn EXT on! We live and learn! I still suspect the keyboard - why not experiment? As for macro, try starting Excel in save mode -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "cphalen" wrote in message ... Pretty sure it is not a keyboard issue. User has 3 PC's and is using synergy software, so same keyboard across all PC's. Problem occurs on 2 of the PC's and not the other one. On my PC I can bring up the extend selection in the status bar either by using F8, or by using the minus key if I have my num lock off, I believe this is normal, however the user with the issue is having the problem wether his num lock is on or off. Could this be caused by a Macro?? "Bernard Liengme" wrote: It is the F8 key that toggles EXT on and off Is it possible the keyboard is the problem? Hope it not a laptop! best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "cphalen" wrote in message ... I have a user running Excel 2007 having problems entering negative numbers with the minus key on the numeric keypad. When he presses the minus key "Extend Selction" shows up in the status bar. He can enter negative numbers from the regular keys. Turning num lock on and off does not resolve the issue. Any ideas on how to fix this? |
#6
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
YES! I can confirm that! Never seen this before. But the, like Bernard, I
always have NumLock on. -- Kind regards, Niek Otten Microsoft MVP - Excel "cphalen" wrote in message ... Trun off your num lock key while in excel and then enter a minus key in a cell using the number key pad and see if EXT shows up in the status bar please. "Bernard Liengme" wrote: I always have NumLock on. I have never seen the minus key turn EXT on! We live and learn! I still suspect the keyboard - why not experiment? As for macro, try starting Excel in save mode -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "cphalen" wrote in message ... Pretty sure it is not a keyboard issue. User has 3 PC's and is using synergy software, so same keyboard across all PC's. Problem occurs on 2 of the PC's and not the other one. On my PC I can bring up the extend selection in the status bar either by using F8, or by using the minus key if I have my num lock off, I believe this is normal, however the user with the issue is having the problem wether his num lock is on or off. Could this be caused by a Macro?? "Bernard Liengme" wrote: It is the F8 key that toggles EXT on and off Is it possible the keyboard is the problem? Hope it not a laptop! best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "cphalen" wrote in message ... I have a user running Excel 2007 having problems entering negative numbers with the minus key on the numeric keypad. When he presses the minus key "Extend Selction" shows up in the status bar. He can enter negative numbers from the regular keys. Turning num lock on and off does not resolve the issue. Any ideas on how to fix this? |
#7
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
This seems quite unrelated, but the end symptom is the same...
http://support.microsoft.com/kb/71434 On Nov 18, 4:53*pm, cphalen wrote: Trun off your num lock key while in excel and then enter a minus key in a cell using the number key pad and see if EXT shows up in the status bar please. "Bernard Liengme" wrote: I always have NumLock on. I have never seen the minus key turn EXT on! We live and learn! I still suspect the keyboard - why not experiment? As for macro, try starting Excel in save mode -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "cphalen" wrote in message ... Pretty sure it is not a keyboard issue. *User has 3 PC's and is using synergy software, so same keyboard across all PC's. *Problem occurs on 2 of the PC's and not the other one. On my PC I can bring up the extend selection in the status bar either by using F8, or by using the minus key if I have my num lock off, I believe this is normal, however the user with the issue is having the problem wether his num lock is on or off. Could this be caused by a Macro?? "Bernard Liengme" wrote: It is the F8 key that toggles EXT on and off Is it possible the keyboard is the problem? Hope it not a laptop! best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "cphalen" wrote in message ... I have a user running Excel 2007 having problems entering negative numbers with the minus key on the numeric keypad. *When he presses the minus key "Extend Selction" shows up in the status bar. *He can enter negative numbers from the regular keys. *Turning num lock on and off does not resolve the issue. Any ideas on how to fix this? |
#8
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Starting in Safe mode produced the same issue....
Any other thoughts?? "Bernard Liengme" wrote: I always have NumLock on. I have never seen the minus key turn EXT on! We live and learn! I still suspect the keyboard - why not experiment? As for macro, try starting Excel in save mode -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "cphalen" wrote in message ... Pretty sure it is not a keyboard issue. User has 3 PC's and is using synergy software, so same keyboard across all PC's. Problem occurs on 2 of the PC's and not the other one. On my PC I can bring up the extend selection in the status bar either by using F8, or by using the minus key if I have my num lock off, I believe this is normal, however the user with the issue is having the problem wether his num lock is on or off. Could this be caused by a Macro?? "Bernard Liengme" wrote: It is the F8 key that toggles EXT on and off Is it possible the keyboard is the problem? Hope it not a laptop! best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "cphalen" wrote in message ... I have a user running Excel 2007 having problems entering negative numbers with the minus key on the numeric keypad. When he presses the minus key "Extend Selction" shows up in the status bar. He can enter negative numbers from the regular keys. Turning num lock on and off does not resolve the issue. Any ideas on how to fix this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
formula results in the status bar | Excel Discussion (Misc queries) | |||
calculate message in status bar | Excel Discussion (Misc queries) | |||
Filter Results in Status Bar | Excel Discussion (Misc queries) | |||
How do I get the filter results to show up in the status bar? | Excel Discussion (Misc queries) | |||
how do i set results to appear in status bar of excel | Excel Discussion (Misc queries) |