Circles

Nigel Martin · Mar 8th, 2002, 02:16 PM

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 ?

Mudface · Mar 8th, 2002, 02:24 PM

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.

Chris Davison · Mar 9th, 2002, 02:38 AM

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.

Nigel Martin · Mar 11th, 2002, 01:33 AM

Thanks guys it solved the problem.

Mar 9th, 2002, 02:38 AM	#3
Chris Davison MrExcel MVP Join Date: Feb 2002 Location: Millbank, London, UK Posts: 1,790	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 ::

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 8th, 2002, 02:16 PM	#1
Nigel Martin Board Regular Join Date: Feb 2002 Posts: 133	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 ?

Mar 8th, 2002, 02:24 PM	#2
Mudface MrExcel MVP Join Date: Feb 2002 Location: Sunny, spring-like Hull Posts: 3,339	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.

Mar 11th, 2002, 01:33 AM	#4
Nigel Martin Board Regular Join Date: Feb 2002 Posts: 133	Thanks guys it solved the problem.