A Check Mark

[Silvia]

Hello, out there!
How do I get a check mark to show up in a cell in a
worksheet? I tried character map and found a checkmark in
the wingdings2. However, when I copy it, I get a "P".

Is there a shortcut method -- like a combination of keys
that will always give me a check mark???

Thanks for your time and expertise.

 

[Michael J. Malinsky]

You need to make sure that the cell formatting is also Wingdings 2.

 

[Ron de Bruin]

Hi Silvia

There is no shortcut but
If the Cell font is Wingdings2 you can use the uppercase P

Did you try the Uppercase P

 

[Don Guillett]

I uses Ron de Bruin's add in available here
http://www.rondebruin.nl/

along with tinyurl.com to get this

http://tinyurl.com/qrj4

 

[cory]

Use insert, then symbol. Then look around the different
options in those menus and you will find a check mark.

 

[Dave Peterson]

One more option:

Format the cell(s) as "wingdings 2", but then apply a custom number format, too:
P;P;P;P



Any set of characters will convert to your check mark. Hit the delete key to
clear the cell.

Then if you need to check if that cell has a checkmark:

=if(a1="","no check","has check")