1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.
  2. You are viewing our forum as a guest. For full access please Register. WindowsBBS.com is completely free, paid for by advertisers and donations.

How do you type 'squared' in Excel??

Discussion in 'Other PC Software' started by Pondlife, 2004/06/10.

Thread Status:
Not open for further replies.
  1. 2004/06/10
    Pondlife

    Pondlife Inactive Thread Starter

    Joined:
    2003/07/09
    Messages:
    80
    Likes Received:
    0
    Trophy Points:
    81
    Location:
    Essex, UK
    Computer Experience:
    Beginner
    You know the little '2' you put next to a number ro show its squared. How do you do this in Excel? I can't find anything in the help for Excel nor in word.

    I'm using Office XP

    Thanks
     
  2. 2004/06/10
    merlin

    merlin Inactive

    Joined:
    2003/01/07
    Messages:
    1,111
    Likes Received:
    0
    Trophy Points:
    206
    Computer Experience:
    par
    Hi, Do you mean how to square a number or how to show the square symbol
    in a cell's description ? eg

    ²
    regards
     

  3. to hide this advert.

  4. 2004/06/10
    PeteC

    PeteC SuperGeek Staff

    Joined:
    2002/05/10
    Messages:
    28,664
    Likes Received:
    363
    Trophy Points:
    1,093
    Location:
    Staffordshire, UK
    Computer Experience:
    Usually not enough
    Try ....

    Format > Cells > Font > Superscript. Works in Office 2003, don't have Office XP
     
  5. 2004/06/10
    Pondlife

    Pondlife Inactive Thread Starter

    Joined:
    2003/07/09
    Messages:
    80
    Likes Received:
    0
    Trophy Points:
    81
    Location:
    Essex, UK
    Computer Experience:
    Beginner
    Yes! :D Exactly like that. How do you do it? :confused:
     
  6. 2004/06/10
    Newt

    Newt Inactive

    Joined:
    2002/01/07
    Messages:
    10,974
    Likes Received:
    2
    Trophy Points:
    608
    Location:
    Concord, NC, USA
    Computer Experience:
    *****
    Hold down the ALT key and from the numberpad, type 0178 then release the ALT key.

    Alt-0178 = ²
    Alt-0179 = ³
    Alt=0190 = ¾
    start~run~charmap gives you the whole list. They work pretty much anywhere in Windows.
     
    Newt,
    #5
    Admin. likes this.
  7. 2004/06/11
    PeteC

    PeteC SuperGeek Staff

    Joined:
    2002/05/10
    Messages:
    28,664
    Likes Received:
    363
    Trophy Points:
    1,093
    Location:
    Staffordshire, UK
    Computer Experience:
    Usually not enough
    In an Excel Cell type 'a' - with the cursor flashing to the right of the 'a' ....
    Format > Cells > Font > check Superscript
    then type '2' which will appear as superscript
    Format > Cells > Font > uncheck Superscript
     
  8. 2004/06/11
    ReggieB

    ReggieB Inactive Alumni

    Joined:
    2004/05/12
    Messages:
    2,786
    Likes Received:
    2
    Trophy Points:
    608
    Location:
    Worcs. UK
    Computer Experience:
    Unabashed deviant
    Why they can't have a button for subscript and superscript as in Word (via customization) is beyond me.

    As no one else mentioned it. If you want squared in an equation you can use ^ as in:

    =2^2

    Which will give 4 in the cell.

    =2^3

    will give 8
     
  9. 2004/06/11
    Pondlife

    Pondlife Inactive Thread Starter

    Joined:
    2003/07/09
    Messages:
    80
    Likes Received:
    0
    Trophy Points:
    81
    Location:
    Essex, UK
    Computer Experience:
    Beginner

    ...Tried that in Word works perfectly, however in Excel it reverts back to the same size font as the a. If I cut and paste from Word into Excel, it reverts it back too??

    The odd thing is it changes, then when you go back to format, cells, font and remove the tick it all changes back to the normal size. Same goes for when you select another cell?? :confused:
     
    Last edited: 2004/06/11
  10. 2004/06/11
    merlin

    merlin Inactive

    Joined:
    2003/01/07
    Messages:
    1,111
    Likes Received:
    0
    Trophy Points:
    206
    Computer Experience:
    par
    Never seen a thread here before with 75 % + UK posts/replies ! :D
    Pleased pondlife got some good tips. Newt mentions the Windows Charmap
    usage. Sometimes you have to juggle around in the different Fonts you have,
    as the character map per Font is different.
    Does anyone have a comprehensive list of the ALT[Number] symbols ?
    regards
     
  11. 2004/06/11
    Pondlife

    Pondlife Inactive Thread Starter

    Joined:
    2003/07/09
    Messages:
    80
    Likes Received:
    0
    Trophy Points:
    81
    Location:
    Essex, UK
    Computer Experience:
    Beginner
    Its ok I've sorted it now, you have to make sure there is a space between the a and the 2 then it will alow you to 'mix fonts' in the same cell.

    Thanks all for your help :)
     
  12. 2004/06/11
    Newt

    Newt Inactive

    Joined:
    2002/01/07
    Messages:
    10,974
    Likes Received:
    2
    Trophy Points:
    608
    Location:
    Concord, NC, USA
    Computer Experience:
    *****
    Merlin - sorry but the only way I know of to get such a list would be to do one.

    Pondlife - isn't this what you were wanting?
     
  13. 2004/06/12
    merlin

    merlin Inactive

    Joined:
    2003/01/07
    Messages:
    1,111
    Likes Received:
    0
    Trophy Points:
    206
    Computer Experience:
    par
    Hi Newt, I am getting on in years. I do not think I will finish
    (9!/4!) combinations (15'120) within what's left to me :D

    Anyway, Edith Starr does as good a job with this topic as anyone :

    ---> here

    regards
     
    Last edited: 2004/06/12
Thread Status:
Not open for further replies.

Share This Page