How do I insert a check mark into a cell?

How do I insert a check mark into a cell?

Post by Mark Charl » Sun, 13 Jul 2003 01:51:38


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
 
 
 

How do I insert a check mark into a cell?

Post by John Wilso » Sun, 13 Jul 2003 02:17:22

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

 
 
 

How do I insert a check mark into a cell?

Post by Steve Andr » Sun, 13 Jul 2003 02:34:20

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