Results 1 to 15 of 15
  1. #1
    3 Star Lounger
    Join Date
    Nov 2001
    Location
    Brooklyn, New York, USA
    Posts
    200
    Thanks
    2
    Thanked 0 Times in 0 Posts

    check mark in times new roman (excel 2003)

    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!

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: check mark in times new roman (excel 2003)

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

    Steve

  3. #3
    3 Star Lounger
    Join Date
    Nov 2001
    Location
    Brooklyn, New York, USA
    Posts
    200
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Re: check mark in times new roman (excel 2003)

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

  4. #4
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: check mark in times new roman (excel 2003)

    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

  5. #5
    3 Star Lounger
    Join Date
    Nov 2001
    Location
    Brooklyn, New York, USA
    Posts
    200
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Re: check mark in times new roman (excel 2003)

    Thanks Steve. Good list to have.

  6. #6
    2 Star Lounger
    Join Date
    Aug 2004
    Posts
    123
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: check mark in times new roman (excel 2003)

    Format the cell font in " Wingdings ",

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

  7. #7
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: check mark in times new roman (excel 2003)

    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:

    <pre>Sub TickMe()

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

    End With

    End Sub
    </pre>


    HTH
    Jerry

  8. #8
    3 Star Lounger
    Join Date
    Nov 2001
    Location
    Brooklyn, New York, USA
    Posts
    200
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Re: check mark in times new roman (excel 2003)

    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!

  9. #9
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: check mark in times new roman (excel 2003)

    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.

  10. #10
    3 Star Lounger
    Join Date
    Nov 2001
    Location
    Brooklyn, New York, USA
    Posts
    200
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Re: check mark in times new roman (excel 2003)

    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.

  11. #11
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: check mark in times new roman (excel 2003)

    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.

  12. #12
    3 Star Lounger
    Join Date
    Nov 2001
    Location
    Brooklyn, New York, USA
    Posts
    200
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Re: check mark in times new roman (excel 2003)

    Lovely, thank you Hans!

  13. #13
    2 Star Lounger
    Join Date
    Feb 2001
    Posts
    163
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Re: check mark in times new roman (excel 2003)

    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.

  14. #14
    Silver Lounger
    Join Date
    Jul 2001
    Location
    Ottawa, Ontario, Canada
    Posts
    1,609
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: check mark in times new roman (excel 2003)

    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?
    Regards
    Don

  15. #15
    3 Star Lounger
    Join Date
    Nov 2001
    Location
    Brooklyn, New York, USA
    Posts
    200
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Re: check mark in times new roman (excel 2003)

    This sounds more labor intensive than the original technique.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •