Results 1 to 7 of 7

Thread: Tick marks

  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Adelaide, South Australia, Australia
    Posts
    387
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Tick marks

    Is it possible to enter tick marks in XL?

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Tick marks

    Do you mean tick marks as in ', which effectively convert numbers to text, or tick marks on a graph ?

  3. #3
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Tick marks

    Or do you mean tick marks like ASCII 251 (which doesn't show up in many Windows fonts)? If so, there's one in the Wingdings Fontset; enter it in Excel as =CHAR(252) and format the cell as Wingdings, then paste it as a value over the top of itself. (There must be a better way, but I can't see it. Convert to a macro if you need it often.)
    -John ... I float in liquid gardens
    UTC -7ąDS

  4. #4
    3 Star Lounger
    Join Date
    Mar 2001
    Location
    Silicon Valley, California, USA
    Posts
    273
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Tick marks

    The "better way" is, make sure NumLock is on, then hold down Alt and type 0252 on the numeric keypad. When you let go, the ASCII character 252 will be generated, without the need to paste special as value.

  5. #5
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Adelaide, South Australia, Australia
    Posts
    387
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Tick marks

    Thanks everyone, I meant tickmarks like the square root symbol. I had tried =Char(n) for all the extended character set in several fonts but not in Wingdings. Alt+0252 (but not Alt+252) works for me in XL97.

  6. #6
    zenood
    Guest

    Re: Tick marks

    You could try this --

    Enter the number 3
    Then change the font for that cell to 'Monotype Sorts'

    I think it's a font usually found on all Windows PC

    This also works in other Windows apps which support character formatting

    Ciao

  7. #7
    Star Lounger
    Join Date
    Jan 2001
    Posts
    93
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Tick marks

    You could also try formatting the chosen cells to use Marlett font. The 'A' key on the keyboard will then give you a tick.

    Paul

Posting Permissions

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