CTRL+SHIFT+$ keyboard shortcut not working

[jaime79]

Hi,

I use the CTRL+SHIFT+$ Currency shortcut often. Recently it's won't format the cell correctly (it only has 1 decimal place & the negative numbers aren't turning red). Below is an example of what I mean:

14500.32 CTRL+SHIFT+$ returns- $14,500.3
-14500.32 CTRL+SHIFT+$ returns- ($14,500.3)

Any idea how to reset the shortcut?

Thanks!
Jaime

 

[xld]

Try typing

Application.OnKey "^+$"

in the VBIDE immediate window.

 

[jaime79]

Thanks for the reply, how do i open the VBIDE immediate window?

 

[xld]

Go to the VBIDE, Alt-F11, open that window, Ctrl-G, and type that statement. It should reset the shortcut key

 

[jaime79]

Thanks, I tried that and it didn't do anything. Do I need to put something in for "procedure"?