How do you insert a tick in exel?

S

Stage2

Hi Lorraine,
I assume you mean a single quote. Since a tick is the signal for Exce
that the following information is a literal (even numbers, dates and s
forth), putting in a single tick mark won't show up by itself. Yo
need to enter two ticks and then only one will show when you click ou
of the cell.
Bruc
 
P

Paul B

Larraine, you could format the cell(s) with the Marlett font, now when you
type in a lowercase a, you get a tick.

Or format the cell(s) with the wingdings font and type alt+0252 and you will
get a tick

Or you could use a macro like this
Sub Insert_Tick_Mark()
With Selection
.Font.Name = "Wingdings"
.Value = Chr(252)
End With
End Sub

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 2003
** remove news from my email address to reply by email **
 
P

Paulw2k

Hi Lorraine

On the Insert menu, click Symbol.

Choose the Square Root (? ) symbol from the mathematical operators subset
and press insert then close buttons.

For me this serves the purpose of a tick.

Regards

Paul
 

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

Top