A Check Mark

  • Thread starter Thread starter Silvia
  • Start date Start date
S

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.
 
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
 
Use insert, then symbol. Then look around the different
options in those menus and you will find a check mark.
 
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")
 
Back
Top