+ Reply to Thread
Results 1 to 4 of 4
  1. #1
    Registered User
    Join Date
    03-23-2009
    Location
    Beirut, Lebanon
    MS-Off Ver
    Excel 2003
    Posts
    10

    Check sign in a Cell

    Can i change the format of a cell to change it from a number for example to a check sign cell?

    If the cell is checked as if it is yes, if its not it is no.

    Is there a way?

    Thank u

  2. #2
    Forum Moderator teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    2003 & 2010
    Posts
    10,042

    Re: Check sign in a Cell

    Hi, you can use the letters a and r and format them with the Marlett font. That will give you the check and the cross.

    hth
    teylyn
    Microsoft MVP - Excel
    At Excelforum, you can say "Thank you!" by clicking the icon below the post.

    Avoid pie charts with more than two data points. Why? See here (pdf, 559 kb). The only acceptable pie chart is here.

  3. #3
    Registered User
    Join Date
    03-23-2009
    Location
    Beirut, Lebanon
    MS-Off Ver
    Excel 2003
    Posts
    10

    Re: Check sign in a Cell

    Teach me how plz I am an amateur

  4. #4
    Forum Moderator teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    2003 & 2010
    Posts
    10,042

    Re: Check sign in a Cell

    Enter the letter a into a cell. Format the cell with the font Marlett.
    teylyn
    Microsoft MVP - Excel
    At Excelforum, you can say "Thank you!" by clicking the icon below the post.

    Avoid pie charts with more than two data points. Why? See here (pdf, 559 kb). The only acceptable pie chart is here.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.2.0