How do you insert a tick in exel?

[Guest]

Please can you tell me how to insert a tick into a cell in excel 2000/2003

 

[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

 

[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 **

 

[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