How do I insert a check mark into a cell?

  • Thread starter Thread starter Mark Charleston
  • Start date Start date
M

Mark Charleston

Is there a way to insert a checkmark into a cell in an
Excel spreadsheet? I have not been able to find an ANSI
character code for check mark...any suggestions would be
greatly appreciated.

Thank you,
Mark Charleston
 
Mark,

Format the cell as Wingdings.
Then hold down the Alt key and type "0252" on the numeric
keyboard and press the Enter key.

John
 
Mark,

This largely depends on what fonts you are willing to
use. One solution would be to select the Wingdings font
and use char(252). Most all installations of Excel come
with this font so it should be safe using this even if you
plan to distribute this workbook to other users.

If you prefer to stay with Arial, there is another pseudo-
solution. Beyond the normal 255 fonts is an Arial font
meant to be the Square Root symbol (√) which resembles a
check mark. This cannot be obtained with the char()
function. You can, however, bring up the Windows
Character Map utility, locate the character, copy it and
paste it in a cell.

Steve
 
Back
Top