+ Reply to Thread
Results 1 to 5 of 5

Wingdings2 Char Code 39 won't display

  1. #1
    Registered User
    Join Date
    08-02-2004
    Location
    Thames Valley Uk
    Posts
    8

    Angry Wingdings2 Char Code 39 won't display

    I'm running Excel 2003; trying to insert in a cell a "phone" symbol which I've inserted via above Char code.

    However in cell it only appears when I double click cell; is there a workround for this please.?
    Thames Valley tapper

  2. #2
    Forum Contributor VBA Noob's Avatar
    Join Date
    04-25-2006
    Location
    London, England
    MS-Off Ver
    xl03 & xl 07(Jan 09)
    Posts
    11,988
    Hi,

    When you click on the cell you see '.
    So what you need to do is add a second one so you now display ''.

    The first one excel is seeing as text.

    VBA Noob

  3. #3
    Forum Contributor VBA Noob's Avatar
    Join Date
    04-25-2006
    Location
    London, England
    MS-Off Ver
    xl03 & xl 07(Jan 09)
    Posts
    11,988
    Or you enter this formula

    =REPT("'",1)

    VBA Noob

  4. #4
    Registered User
    Join Date
    08-02-2004
    Location
    Thames Valley Uk
    Posts
    8

    Cure

    Many thanks
    Many Thanks!!

  5. #5
    Registered User
    Join Date
    03-09-2012
    Location
    paris, france
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Wingdings2 Char Code 39 won't display


+ Reply to Thread

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