ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   can you put a tick into an excel cell? (https://www.excelbanter.com/excel-discussion-misc-queries/16518-can-you-put-tick-into-excel-cell.html)

Thunderace

can you put a tick into an excel cell?
 



hi
no. you can put a tick on the sheet but not "in" a cell.

-----Original Message-----

.


Sandy Mann

Thunderace,

in cell A33 enter the formula =CHAR(ROW()) and copy down to row 255

With the range still highlighted, change the font to Wingdings and you will
see the full Wingdings character set. Character 252 is a tick sign. You
can enter the tick in a cell either by the formula =CHAR(252) with the cell
font set to Wingdings or by holding the the Alt key while you enter 0252
from the number pad keys.

Also have a look to see the full charater set of the other fonts that you
have out of interest.

HTH

Sandy

--
to e-mail direct replace @mailinator.com with @tiscali.co.uk


"Thunderace" wrote in message
...




Jim May

In the cell you want to show the CHECK-MARK
enter the letter "a" -- without the quotes
Then assign the font "Marlett"



"Sandy Mann" wrote in message
...
Thunderace,

in cell A33 enter the formula =CHAR(ROW()) and copy down to row 255

With the range still highlighted, change the font to Wingdings and you

will
see the full Wingdings character set. Character 252 is a tick sign. You
can enter the tick in a cell either by the formula =CHAR(252) with the

cell
font set to Wingdings or by holding the the Alt key while you enter 0252
from the number pad keys.

Also have a look to see the full charater set of the other fonts that you
have out of interest.

HTH

Sandy

--
to e-mail direct replace @mailinator.com with @tiscali.co.uk


"Thunderace" wrote in message
...







All times are GMT +1. The time now is 09:17 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com