View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.misc
Rick Rothstein \(MVP - VB\) Rick Rothstein \(MVP - VB\) is offline
external usenet poster
 
Posts: 2,202
Default How does one insert an "R" With a CIRCLE AROUND IT?

The "trick" REQUIRES the numbers be typed out on a numeric keypad; the
numbers on the main keyboard cannot be used. I don't know why that is, but
this functionality goes back to the earliest days the DOS operating system
and it has always required the number pad be used for entering the numbers.

If you don't have a separate number pad, then I assume the embedded one your
laptop can be used. Usually you activate the embedded number pad by using a
function key of some kind (perhaps a special function key for just that
purpose or perhaps a function-type shift key in combination with some other
normal function key). If you have never used your embedded number pad, see
your laptop's documentation on how to activate it.

Rick


"writermon" wrote in message
...
Dear Rick,

what if one does not have a separate numeric keypad? when i use the
numbers
up top nothing happens.

tx,
Eric


"Rick Rothstein (MVP - VB)" wrote:

If you are using a PC (not sure if this will work on a Mac or not), you
can enter it directly from the keyboard. Wherever you want that symbol
at
(either during the typing of the original text or by moving the caret
to
an insert location), hold down the ALT key (and keep it down) while
typing
0174 on the number pad. IMPORTANT... you must use the number pad to
enter
those numbers and the zero cannot be omitted.


I guess I should expand on the above a little bit. On a PC, you can
physically type any character defined in a font with an ANSI value
(sometimes mis-called an ASCII value) of 128 or above (maximum 255) using
the above technique. Simply hold down the ALT key and key in 0 followed
by
the three-digit ANSI code from the number pad and that character will be
"typed" in your text string.

Rick