Any font to surround number with a circle?

Discussion in 'Microsoft Excel Misc' started by Flamikey, Sep 28, 2004.

  1. Flamikey

    Flamikey Guest

    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

    --
    Flamike
    -----------------------------------------------------------------------
    Flamikey's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=461
    View this thread: http://www.excelforum.com/showthread.php?threadid=26430
     
    Flamikey, Sep 28, 2004
    #1
    1. Advertisements

  2. Flamikey

    Myrna Larson Guest

    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.

    On Tue, 28 Sep 2004 11:54:44 -0500, Flamikey
    <> wrote:

    >
    >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 number
    >entered into the cell to be encircled and not insert a drawing shape on
    >top of the cell and then type in a number within the shape. Does
    >Wingdings or another font have this capability? Thanks!
     
    Myrna Larson, Sep 28, 2004
    #2
    1. Advertisements

  3. Flamikey

    mzehr Guest

    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
    >-----Original Message-----
    >
    >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 number
    >entered into the cell to be encircled and not insert a

    drawing shape on
    >top of the cell and then type in a number within the

    shape. Does
    >Wingdings or another font have this capability? Thanks!
    >
    >
    >--
    >Flamikey
    >----------------------------------------------------------

    --------------
    >Flamikey's Profile: http://www.excelforum.com/member.php?

    action=getinfo&userid=4612
    >View this thread:

    http://www.excelforum.com/showthread.php?threadid=264306
    >
    >.
    >
     
    mzehr, Sep 28, 2004
    #3
  4. Flamikey

    Guest 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.

    >-----Original Message-----
    >
    >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 number
    >entered into the cell to be encircled and not insert a

    drawing shape on
    >top of the cell and then type in a number within the

    shape. Does
    >Wingdings or another font have this capability? Thanks!
    >
    >
    >--
    >Flamikey
    >----------------------------------------------------------

    --------------
    >Flamikey's Profile: http://www.excelforum.com/member.php?

    action=getinfo&userid=4612
    >View this thread:

    http://www.excelforum.com/showthread.php?threadid=264306
    >
    >.
    >
     
    Guest, Sep 28, 2004
    #4
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Flamikey

    Any font to surround number with a circle?

    Flamikey, Sep 28, 2004, in forum: Microsoft Excel Misc
    Replies:
    1
    Views:
    208
    Myrna Larson
    Sep 28, 2004
  2. Flamikey

    Any font to surround number with a circle?

    Flamikey, Sep 29, 2004, in forum: Microsoft Excel Misc
    Replies:
    0
    Views:
    377
    Flamikey
    Sep 29, 2004
  3. Guest
    Replies:
    2
    Views:
    367
    Don Guillett
    Mar 8, 2005
  4. novastar102c

    HOW DO I SURROUND DATA WITH COLORFUL MARCHING ANTS

    novastar102c, Nov 10, 2008, in forum: Microsoft Excel Misc
    Replies:
    2
    Views:
    296
    Herbert Seidenberg
    Nov 11, 2008
  5. Teresa

    how do i circle a number?

    Teresa, May 5, 2009, in forum: Microsoft Excel Misc
    Replies:
    1
    Views:
    338
    Kevin B
    May 5, 2009
Loading...

Share This Page