How do you insert a tick in exel?

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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 **
 
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
 
Back
Top