+ Reply to Thread
Results 1 to 2 of 2

Wingdings and Character numbers

  1. #1
    Forum Contributor
    Join Date
    10-31-2006
    Location
    Oslo, Norway
    MS-Off Ver
    MS 365 Business
    Posts
    286

    Wingdings and Character numbers

    Please see the attached file.
    I have inserted A1 and A2 with use of Insert/Symbols/Wingdings.

    I want to use these symbols (stars) in a formula. When I do so, other characters are shown, namely the characters which are shown in the formula bar when mouse pointer is in A1 and A2.
    And these are character 182 and 171 respectively.

    Could someone explain why this is so, and how I could use the star symbols in a formula?
    Attached Files Attached Files

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,441

    Re: Wingdings and Character numbers

    You need to change the font of the cells that contain the formula.
    Cheers
    Andy
    www.andypope.info

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Countif with wingdings fonts
    By puuts in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-24-2014, 01:01 AM
  2. AutoCAD icons needed in Excel (not wingdings)
    By Troutman12 in forum Excel General
    Replies: 2
    Last Post: 02-17-2014, 12:18 PM
  3. Excel 2007 : change fron from comic sans to wingdings
    By Spike0907 in forum Excel General
    Replies: 3
    Last Post: 02-10-2010, 03:47 PM
  4. Wingdings Char value for ZERO
    By PRodgers4284 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-06-2009, 11:56 AM
  5. Counting Wingdings
    By scotfitz in forum Excel General
    Replies: 9
    Last Post: 09-20-2009, 02:00 PM
  6. Replies: 0
    Last Post: 07-06-2006, 03:20 PM
  7. Wingdings
    By davids in forum Excel General
    Replies: 0
    Last Post: 03-16-2006, 06:45 PM

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.6.0 RC 1