I need to put 'ticks' and 'smiley faces' into cells in Excel 2000. These
characters are in Windings. I set shortcut keys for both characters in Word
but these shortcut keys do not work when in Excel. None of the normal
keystrokes I try in Windings when in Excel will give me these characters.

Format a cell to Wingdings, and just enter an uppercase J for a smiley face.

In Windings2, an upper case P produces a tick.

I mention these because they are single keystrokes.


--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Mulberry" wrote in message
...
I need to put 'ticks' and 'smiley faces' into cells in Excel 2000. These
characters are in Windings. I set shortcut keys for both characters in
Word
but these shortcut keys do not work when in Excel. None of the normal
keystrokes I try in Windings when in Excel will give me these characters.

Hello, thanks for your help. I was hoping for keystrokes for both characters
in the same font as the entry of ticks and smileys is random and I will have
to format each cell to either windings or windings 2 as I go. Am attempting a
macro on the keystrokes in the other post. Thanks again

"RagDyer" wrote:

Format a cell to Wingdings, and just enter an uppercase J for a smiley face.

In Windings2, an upper case P produces a tick.

I mention these because they are single keystrokes.


--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Mulberry" wrote in message
...
I need to put 'ticks' and 'smiley faces' into cells in Excel 2000. These
characters are in Windings. I set shortcut keys for both characters in
Word
but these shortcut keys do not work when in Excel. None of the normal
keystrokes I try in Windings when in Excel will give me these characters.

Alt + 0074, 0075 and 0076 are the 3 smiley/frowny/yucky characters..........0252
is the tick

Type the numbers on the Numpad, not the keys above qwerty


Gord Dibben MS Excel MVP

On Tue, 19 Feb 2008 14:34:02 -0800, Mulberry
wrote:

I need to put 'ticks' and 'smiley faces' into cells in Excel 2000. These
characters are in Windings. I set shortcut keys for both characters in Word
but these shortcut keys do not work when in Excel. None of the normal
keystrokes I try in Windings when in Excel will give me these characters.

Thank you very much, extremely helpful... I now have a macro for each
character but ......... I will sometimes need to enter 2 or more characters
in a cell. I can do this using the keystrokes that you gave me but not with
the maros built on the keystrokes; with the macros the the cell won't take a
second character. Any suggestions. Many thanks

"Gord Dibben" wrote:

Alt + 0074, 0075 and 0076 are the 3 smiley/frowny/yucky characters..........0252
is the tick

Type the numbers on the Numpad, not the keys above qwerty


Gord Dibben MS Excel MVP

On Tue, 19 Feb 2008 14:34:02 -0800, Mulberry
wrote:

I need to put 'ticks' and 'smiley faces' into cells in Excel 2000. These
characters are in Windings. I set shortcut keys for both characters in Word
but these shortcut keys do not work when in Excel. None of the normal
keystrokes I try in Windings when in Excel will give me these characters.

Suggestions?

Nothing comes to mind that will let you stick multiple smilies or ticks without
a specific macro.


Gord

On Tue, 19 Feb 2008 21:25:00 -0800, Mulberry
wrote:

Thank you very much, extremely helpful... I now have a macro for each
character but ......... I will sometimes need to enter 2 or more characters
in a cell. I can do this using the keystrokes that you gave me but not with
the maros built on the keystrokes; with the macros the the cell won't take a
second character. Any suggestions. Many thanks

"Gord Dibben" wrote:

Alt + 0074, 0075 and 0076 are the 3 smiley/frowny/yucky characters..........0252
is the tick

Type the numbers on the Numpad, not the keys above qwerty


Gord Dibben MS Excel MVP

On Tue, 19 Feb 2008 14:34:02 -0800, Mulberry
wrote:

I need to put 'ticks' and 'smiley faces' into cells in Excel 2000. These
characters are in Windings. I set shortcut keys for both characters in Word
but these shortcut keys do not work when in Excel. None of the normal
keystrokes I try in Windings when in Excel will give me these characters.