Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Circles

  1. #1
    Board Regular
    Join Date
    Feb 2002
    Posts
    133
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Is there any way that numbers in Excel can be circled. I have tried using the Windows Character Map but that only goes up to 10 ?

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Sunny, spring-like Hull
    Posts
    3,339
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Possibly not what you want but there is a way. Select the cells you want to be circled, click on Data-Validation and enter a validation condition to suit the cells you want to be circled. Then click on Tools-Auditing and show the Auditing toolbar. Click on the icon with the tooltip 'Circle invalid data'. I'm not sure if you can format the circle (it can look a bit odd), and apologies if this isn't what you meant.

  3. #3
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Millbank, London, UK
    Posts
    1,790
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    autoshapes might help too

    insert
    picture
    autoshapes
    flowchart

    there's a circle in there, drag it over your cell and adjust the size n shape : it defaults to non-transparent, hiding your number, so right click on it

    format auto shape
    fill colour = no fill

    not sure you can automate it via relative macro cos of the placing, but you can copy paste the circle as normal.


    :: Pharma Z - Family drugstore ::

  4. #4
    Board Regular
    Join Date
    Feb 2002
    Posts
    133
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thanks guys it solved the problem.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •