Any font to surround number with a circle?

[Flamikey]

Looking to have a number surrounded with a circle to use for footnoting
however I'd like to use a font that automatically formats the numbe
entered into the cell to be encircled and not insert a drawing shape o
top of the cell and then type in a number within the shape. Doe
Wingdings or another font have this capability? Thanks

 

[Myrna Larson]

The Character Map utility that's part of Windows will show you which
characters are available. There are numbers 1-10 in Windings2, but I'm not
sure this will help you: the ASCII code for the 1 in a circle is 106, which
has absolutely nothing to do with the binary representation of the number 1.

If you require this format, I think you'll have to do it manually.

 

[mzehr]

Hi,
AFAIK, Wingdings1 and Wingdings2 have that feature, but
only numbers 0-10, and they don't correlate with your
numbers 0-10.
In other words you would need to put in Alt - 0 plus the
character code for the related symbol. For example you
would need to format the cell for wingdings and alt 0145
will give you a 6 with a dark circle around it.

Hope this helps

 

[Guest]

hi,
windkings2 lower case for letters j to s will get you 1 to
10 with a circle. but you would have to do that manually.
for other characters....
=CHAR(Row())
in a blank workbook, copy that and paste it down to row
255.