If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
how do i use symbol of degree in excell work sheet using key board
to use symbol of degree " ° "
I have to go to start+programs+accessories+systom tools+character Map+search for degree U+00B0EGREE SIGN KEY STROKE:Alt+0176 Iused the key stroke Alt + 0176 But degree sign ° does not appear in the excell sheet cell or on the office document , is there any easy method Please advise Amitwills |
#2
|
|||
|
|||
how do i use symbol of degree in excell work sheet using key board
When you hold the Alt key down, are you using the keys on the numeric keypad
to the right of your keyboard to enter 0176 It does not work if using the keys along top of keyboard. Don't know how you get on if it is a notebook without numeric keypad. Another way you can do it is in any cell enter the formula =CHAR(176) and then copy-paste special-values to remove the formula. You can then select the cell and highlight the character in the formula bar and copy it and then paste it into another formula. -- Regards, OssieMac "amitwills" wrote: to use symbol of degree " ° " I have to go to start+programs+accessories+systom tools+character Map+search for degree U+00B0EGREE SIGN KEY STROKE:Alt+0176 Iused the key stroke Alt + 0176 But degree sign ° does not appear in the excell sheet cell or on the office document , is there any easy method Please advise Amitwills |
#3
|
|||
|
|||
how do i use symbol of degree in excell work sheet using key board
You could set up a Custom Format for cells you wish to have the degree
symbol appear in. Type a zero(0) then hold Alt key and 0176 on the NumPad as Ossiemac points out. Gord Dibben MS Excel MVP On Mon, 4 Aug 2008 18:16:00 -0700, amitwills wrote: to use symbol of degree " ° " I have to go to start+programs+accessories+systom tools+character Map+search for degree U+00B0EGREE SIGN KEY STROKE:Alt+0176 Iused the key stroke Alt + 0176 But degree sign ° does not appear in the excell sheet cell or on the office document , is there any easy method Please advise Amitwills |
Thread Tools | |
Display Modes | |
|
|