check mark in times new roman (excel 2003)

Topic

New Reply

Is there anyway to create a checkmark in TNR? I’m so tired of going around changing all the checkmarks to wingdings when I make links into a new document! I’m assuming this is the same for word, but I happen to be working in excel.
thanks!

Reply | Quote

Replies

You can hold and enter 251 (from num keypad) to get the square root symbol which is close to a check mark…

Steve

Reply | Quote

Yeah, I didn’t really want to do that. It looks like a square root.

Reply | Quote

There is a list of them at: ASCII Code List for numpad Characters

I thik the square root is the closest you will find in most of the “text fonts”. To get a real check mark, I think you have to use one of the “symbol fonts” (like wingdings) …

Steve

Reply | Quote

Thanks Steve. Good list to have.

Reply | Quote

Format the cell font in ” Wingdings “,

then, hold and enter 0252 ( from the num keypad)

Reply | Quote

Hi Naomi

I used to have Project Managers always asking me this question as they used to get fed up with manually changing the font to Wingdings.

I used to tell them to record a macro and assign a keyboard shortcut. The macro can be cut down a tad and still work but looks similar to this:

Sub TickMe()

    ActiveCell.FormulaR1C1 = "ü"
    With ActiveCell.Characters(Start:=1, Length:=1).Font
        .Name = "Wingdings"
        
    End With
    
End Sub

HTH

Reply | Quote

Hey Jerry, great answer. I love macros. I guess this is the only workaround. I suppose a checkmark wasn’t high on the list when ASCII was invented!

Reply | Quote

The original ASCII character set had only 128 characters, of which the first 32 are non-printing control characters, so 96 “real characters”. With 26 upper case letters, 26 lower case letters and 10 digits, there wasn’t much room for other things.
Later, ASCII was extended to 256 characters, adding letters with diacritics (accents) and some graphic symbols, but still not a check mark.

When computer video went from character-based to graphic, it became possible to use different fonts, and symbol fonts were developed that include a check mark character.
Unicode fonts such as Arial MS Unicode also have it.

Reply | Quote

Hans, you’ve nailed it, thank you, I’ve switched my font over to unicode, found the check mark and saved myself a ton of time! Thank you! Now just to expand (or hijack) upon this post for a minute, does anyone know how to copy a format a paste it to a lot of cells, or copy a cell and paste it to a lot of cells all at once? That way I can take care of the checkmarks yet another way.

Reply | Quote

You can use the Format Painter button on the Formatting toolbar to copy the format of a cell to a range of other cells:
– Select the “source” cell.
– Click the Format Painter button.
– Select the “target” cells.
Normally, the Format Painter button will turn itself off when you select the target cells. But if you double-click it, it will remain active so that you can apply the format to several ranges, until you click the button again or press Esc.

To copy the contents of a cell to other cells:
– Select the “source” cell.
– Press Ctrl+C or click the Copy button on the Formatting toolbar.
– Select the “target” cells.
– Press Ctrl+V or click the Paste button on the Formatting toolbar.
– If desired, repeat the last two steps.

Reply | Quote

Lovely, thank you Hans!

Reply | Quote

Another method is to put a ^ in front of the formula, copy it to as many cells as you want, then block the cells and use find and replace. Find the ^ and replace it with nothing.

Reply | Quote

I thought that you had identified a new paste special technique when I read your post; but find it does nothing but remove any carets from formulae. Exactly what are the expected results of this method?

Reply | Quote

This sounds more labor intensive than the original technique.

Reply | Quote