Inserting a "tick"

G

Guest

I wonder if anyone can advise me how I can insert a "tick" symbol into a
cell ?

i.e, like a tick that goes in a box if something applies to you, or
whatever,

I know it is in MS word, under "windings" , but cant seem to find it in
Excel.

Many thanks

Bob
 
M

Macroman

You could enter on the worksheet the following formula

=char(252)

This is the ASCII for the tick, just format the cell as Wingding font.

Macroman
 
N

njmarshall55

If you do use the =char function in a conditional "if" statement, just
remember to drop the =.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Creating a checklist with predefined comments 1
how I can insert a "tick" symbol 3
tick not check box X 1
Loop through pages and insert header image 0
Insert Index into a Table 1
Inserting a Symbol and Text into a Bookmark 4
How do I insert a check box in Excel Vista? I'm a novice 1
Documents Not Appearing (as it used to) On Desktop ? [on a Mac] 0

Top