ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I make a check mark? (https://www.excelbanter.com/excel-discussion-misc-queries/44031-how-do-i-make-check-mark.html)

kentrks

How do I make a check mark?
 
When I use the code for a checkmark (alt 80) in Excel, I get the letter P
instead of the checkmark. In fact I tried several symbol shortcuts (alt +
code) and got all letters. What am I missing?

Dave Peterson

I use =char(252) (alt-0252)
and a wingdings font.

If you're using xl2002, you could find more checkmarks via Insert|symbol

Chip Pearson has an addin that may help (if you're using xl2k or lower).
http://www.cpearson.com/excel/download.htm
(look for Symbolizer and make sure you get the correct version)
kentrks wrote:

When I use the code for a checkmark (alt 80) in Excel, I get the letter P
instead of the checkmark. In fact I tried several symbol shortcuts (alt +
code) and got all letters. What am I missing?


--

Dave Peterson

Bruce Sinclair

In article , wrote:
I use =char(252) (alt-0252)
and a wingdings font.

If you're using xl2002, you could find more checkmarks via Insert|symbol

Chip Pearson has an addin that may help (if you're using xl2k or lower).
http://www.cpearson.com/excel/download.htm
(look for Symbolizer and make sure you get the correct version)
kentrks wrote:

When I use the code for a checkmark (alt 80) in Excel, I get the letter P
instead of the checkmark. In fact I tried several symbol shortcuts (alt +
code) and got all letters. What am I missing?


... and if you want to see what symbol you will get, try insert/symbol and
pick one you like. Remember not to change the font later though :)





Bruce

----------------------------------------
I believe you find life such a problem because you think there are the good
people and the bad people. You're wrong, of course. There are, always and
only, the bad people, but some of them are on opposite sides.

Lord Vetinari in Guards ! Guards ! - Terry Pratchett

Caution ===== followups may have been changed to relevant groups
(if there were any)


Joy[_2_]

How do I make a check mark?
 
Thank you for making it easy for many, many individuals to make a check mark
in Excel.

url:http://www.ureader.com/msg/103414256.aspx


All times are GMT +1. The time now is 10:19 AM.

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