Page 1 of 2 12 LastLast
Results 1 to 10 of 11

division symbol

This is a discussion on division symbol within the Excel Questions forums, part of the Question Forums category; I want to add the division symbol (char 247) to cells in my spreadsheet. I have used similar keystrokes before ...

  1. #1
    New Member
    Join Date
    Apr 2003
    Posts
    4

    Default division symbol

    I want to add the division symbol (char 247) to cells in my spreadsheet. I have used similar keystrokes before when adding the degree symbol by typing ALT + 176, but for some reason neith this not any of the other character keystrokes work.

    Perhaps I am forgetting something simple????

    Thanks for your help

    Dave

  2. #2
    Board Regular
    Join Date
    Jul 2002
    Location
    Nurmijärvi, Finland
    Posts
    148

    Default

    ALT + 0247

    Sir Vili

  3. #3
    Board Regular
    Join Date
    Dec 2002
    Location
    ashbourne, derbyshire, uk
    Posts
    144

    Default

    Dave,

    I've had this sort of trouble too. The Sir Villi solution to your problem didn't work for me. Neither does this approach work for other symbols I've needed
    eg: Typing Alt+0189 does not give me the "half" symbol that I wanted and that the "Character Map" seems to suggest it should produce. Rather I get a "crossed c", which the "character Map" suggests should be associated with Alt+0162. What's going on here?

    I've always concluded the problem was something to do with US/UK keyboard mapping or something...but I hope this is wrong and someone can enlighten us or provide an algorithm for converting the "Character Map" code into the one actually needed.

    Rob

  4. #4
    Board Regular
    Join Date
    Jul 2002
    Location
    Nurmijärvi, Finland
    Posts
    148

    Default

    Hi.

    What about giving to formula =Char(247). Then take copy of that cell and Edit Paste Special Values in same cell.

    Hope this helps.

    Sir Vili.

  5. #5
    Board Regular
    Join Date
    Dec 2002
    Location
    ashbourne, derbyshire, uk
    Posts
    144

    Default

    Yeah... That's pretty much the way I have been getting round the "problem" so far.... ...But, for my own peace of mind, I'd still like to know WHY typing an "Alt + digits" string doesn't produce the desired/expected affect.

    (Sorry Dave...didn't intend to hijack your question )


    Rob

  6. #6
    Board Regular
    Join Date
    Dec 2002
    Posts
    1,179

    Default

    Press Alt (don't release the keyboard) typing 0247 and release Alt

  7. #7
    MrExcel MVP tusharm's Avatar
    Join Date
    May 2002
    Posts
    10,924

    Default

    The keyboard mapping may be relevant; I don't know. But, one definite relevant context is the font used. For Arial, ALT+0189 does result in the 1/2 symbol, just as ALT+0247 yields the division symbol.

  8. #8
    Board Regular
    Join Date
    Dec 2002
    Location
    ashbourne, derbyshire, uk
    Posts
    144

    Default

    Sorry guys...I AM holding Alt key down while I type the four digits, and I AM using Arial font and ALT+0189 still gives me the "crossed c" instead of "half". Alt +0247 gives nothing but a 1 line pull-down box, certainly not the division symbol.

    (Incidently, I'm using the numerals on the numeric keypad here...if I use the ones at the top of the normal keypad I get nothing at all.

    Also I get identical behaviour on both my PC at work and the one at home)




    What do you get Dave?


    Rob

  9. #9
    Board Regular shades's Avatar
    Join Date
    Mar 2002
    Location
    Near the Land of Oz
    Posts
    1,550

    Default

    Just out of curiosity, is NumLock on?
    - old, slow, and confused
    ... but at least I'm inconsistent -

    (retired Excel 2003 user, 3.28.2008)

  10. #10
    Board Regular
    Join Date
    Dec 2002
    Location
    ashbourne, derbyshire, uk
    Posts
    144

    Default

    Get same effect whetehr its on or off Alt+0189 gives "crossed c" in both cases

    Rob

Page 1 of 2 12 LastLast

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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


DMCA.com