Possible to create a number 1 centered inside a circle?

[Jennifre]

Hello, I am hoping to learn how to create a number centered vertically + horizontally inside of a circle if possible.

I have 0 idea how to use VBA, if that is a factor to achieve this.

I need to be able to put the number 1 centered inside a circle, then to be able to copy + paste these as markers in my spreadsheet.

Is there a fairly simple manner of creating such a thing?

Thank you in advance!!

 

[FormR]

You could try this formula which you can copy and paste as values to other parts of your spreadsheet.

=UNICHAR(9312)

 

[Macropod]

You don't need any VBA for that. Such characters already exist in the Segoe UI Symbol font, Wingdings font, Wingdings2 font, etc. Some fonts have multiple forms.

 

[Jennifre]

You could try this formula which you can copy and paste as values to other parts of your spreadsheet.

=UNICHAR(9312)

Oh cool, thank you!!

Is there any way I can make this larger?

May I change its number? (Not sure how many numbers I will need to use? I'm going to be assigning a number for every category of data I see, so, it's unknown, yet.)

Thank you again!!

 

[FormR]

Is there any way I can make this larger?

Hi, just increase the font size.

May I change its number?

Take a look here:
Enclosed Alphanumerics – Test for Unicode support in Web browsers

The decimal numbers are what you pass to the UNICHAR() function - or you can simply copy and paste the characters directly from the website into Excel.

 

[Jennifre]

Hi, just increase the font size.


Take a look here:
Enclosed Alphanumerics – Test for Unicode support in Web browsers

The decimal numbers are what you pass to the UNICHAR() function - or you can simply copy and paste the characters directly from the website into Excel.

Your references are so generous, thank you!

I'm proving quite moronic understanding this unicode format, however, and am unable to see the pattern unicode must be using to indicate the numeral change within its format.

If that is simple to indicate to me, I would be very charmed to understand it. Thank you so much for your communications!

 

[FormR]

unable to see the pattern unicode must be using to indicate the numeral change within its format.

Hi, there's no pattern or logic as such, each and every character in the standard has it's own unique number, some groups of similar characters are in blocks of numbers but that isn't always the case.

See here for a bit more info : What is Unicode?

 

[Jennifre]

Hi, there's no pattern or logic as such, each and every character in the standard has it's own unique number, some groups of similar characters are in blocks of numbers but that isn't always the case.

See here for a bit more info : What is Unicode?

My, how unfriendly of it!