Check box

D

David French

I have a user that wants to put a checkmark in a cell as a yes or no to each
record (row) that either has a contract or not.
I tried putting in the form field but that really doesn't seem to be it.
I tried to talk her into simply putting an X in the cell but she would
really rather the checkmark.

Any ideas??

Dave French
 
B

Bob Umlas

Change the cell to Wingdings font, then, holding the Alt key down, type 0252
on the numeric keypad (not regular #s), then let go of the Alt key. Or,
enter =CHAR(252).

Bob Umlas
Excel MVP
 
B

Bob Phillips

as will Marlett and 'a'

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
D

David French

Thank you ALL!!
These are all great suggestions and my user is very happy!!

Dave French
 
Top