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
|
|||
|
|||
Symbols
I am trying to put in a cell "30Û« ~35Û« " but when I do it switches the 35Û« to
53Û«. I have tried the cell format on "general" and "text" as well as the "number" but they all do this. Why is it doing this and how can I stop it? |
#2
|
|||
|
|||
Symbols
As I asked yesterday, how are you inputting the symbols (degree symbol)?
Excel version? "Crissy" wrote: I am trying to put in a cell "30Û« ~35Û« " but when I do it switches the 35Û« to 53Û«. I have tried the cell format on "general" and "text" as well as the "number" but they all do this. Why is it doing this and how can I stop it? |
#3
|
|||
|
|||
Symbols
Sorry Im just learning how to use this web site. To put the degree symbol in
am going to "Insert Symbol" and then inserting it to the text. The excel version that I am using is Microsoft Office Excel 2003. "Sheeloo" wrote: As I asked yesterday, how are you inputting the symbols (degree symbol)? Excel version? "Crissy" wrote: I am trying to put in a cell "30Û« ~35Û« " but when I do it switches the 35Û« to 53Û«. I have tried the cell format on "general" and "text" as well as the "number" but they all do this. Why is it doing this and how can I stop it? |
#4
|
|||
|
|||
Symbols
Try this
30°~35° and see whether it works... In Insert Symbol look for degree sign (ASCII 176) Pl. look for the character code (ASCII value) and name of the symbol you are inserting and let us know... -- Pl click the YES button (if you see it - don''''''''t worry if you don''t), if this answer was helpful. "Crissy" wrote: Sorry Im just learning how to use this web site. To put the degree symbol in am going to "Insert Symbol" and then inserting it to the text. The excel version that I am using is Microsoft Office Excel 2003. "Sheeloo" wrote: As I asked yesterday, how are you inputting the symbols (degree symbol)? Excel version? "Crissy" wrote: I am trying to put in a cell "30۫ ~35۫ " but when I do it switches the 35۫ to 53۫. I have tried the cell format on "general" and "text" as well as the "number" but they all do this. Why is it doing this and how can I stop it? |
#5
|
|||
|
|||
Symbols
You are inserting the symbol in the appropriate spot in the formula bar
after hitting F2 to edit? Should work OK. Have you checked your Autocorrect list for entries that would change 35° degrees to 53°? What happens if you just enter 35 then insert a symbol or type 35 then Alt + 0176 on the Numpad? Gord Dibben MS Excel MVP On Tue, 14 Apr 2009 13:44:01 -0700, Crissy wrote: Sorry Im just learning how to use this web site. To put the degree symbol in am going to "Insert Symbol" and then inserting it to the text. The excel version that I am using is Microsoft Office Excel 2003. "Sheeloo" wrote: As I asked yesterday, how are you inputting the symbols (degree symbol)? Excel version? "Crissy" wrote: I am trying to put in a cell "30? ~35? " but when I do it switches the 35? to 53?. I have tried the cell format on "general" and "text" as well as the "number" but they all do this. Why is it doing this and how can I stop it? |
#6
|
|||
|
|||
Symbols
Gord,
Try to copy the values posted by Crissy (excluding the quotes) and paste in any cell... you will see what happens... I suspect it is due to the code of the degree symbol being inserted (not the one I inserted successfully)... I am not sure why but I could replicate what by copying and pasting... I have copied it below 30۫ ~35۫ "Gord Dibben" wrote: You are inserting the symbol in the appropriate spoot in the formula bar after hitting F2 to edit? Should work OK. Have you checked your Autocorrect list for entries that would change 35° degrees to 53°? What happens if you just enter 35 then insert a symbol or type 35 then Alt + 0176 on the Numpad? Gord Dibben MS Excel MVP On Tue, 14 Apr 2009 13:44:01 -0700, Crissy wrote: Sorry Im just learning how to use this web site. To put the degree symbol in am going to "Insert Symbol" and then inserting it to the text. The excel version that I am using is Microsoft Office Excel 2003. "Sheeloo" wrote: As I asked yesterday, how are you inputting the symbols (degree symbol)? Excel version? "Crissy" wrote: I am trying to put in a cell "30? ~35? " but when I do it switches the 35? to 53?. I have tried the cell format on "general" and "text" as well as the "number" but they all do this. Why is it doing this and how can I stop it? |
#7
|
|||
|
|||
Symbols
I copied your 30? - 35? and have no changes made when pasted.
I also copied Crissy's original sample but could not get a change so for me "you will see what happens" is nothing. Did you mean to post 30° - 35° Which also pastes with no changes. Gord On Tue, 14 Apr 2009 15:32:01 -0700, Sheeloo just remove all As... wrote: Gord, Try to copy the values posted by Crissy (excluding the quotes) and paste in any cell... you will see what happens... I suspect it is due to the code of the degree symbol being inserted (not the one I inserted successfully)... I am not sure why but I could replicate what by copying and pasting... I have copied it below 30? ~35? "Gord Dibben" wrote: You are inserting the symbol in the appropriate spoot in the formula bar after hitting F2 to edit? Should work OK. Have you checked your Autocorrect list for entries that would change 35° degrees to 53°? What happens if you just enter 35 then insert a symbol or type 35 then Alt + 0176 on the Numpad? Gord Dibben MS Excel MVP On Tue, 14 Apr 2009 13:44:01 -0700, Crissy wrote: Sorry Im just learning how to use this web site. To put the degree symbol in am going to "Insert Symbol" and then inserting it to the text. The excel version that I am using is Microsoft Office Excel 2003. "Sheeloo" wrote: As I asked yesterday, how are you inputting the symbols (degree symbol)? Excel version? "Crissy" wrote: I am trying to put in a cell "30? ~35? " but when I do it switches the 35? to 53?. I have tried the cell format on "general" and "text" as well as the "number" but they all do this. Why is it doing this and how can I stop it? |
#8
|
|||
|
|||
Symbols
I forgot to mention that I am using a browser...IE and Firefox
and copying what Crissy has posted... take what is between the quotes... "Gord Dibben" wrote: I copied your 30? - 35? and have no changes made when pasted. I also copied Crissy's original sample but could not get a change so for me "you will see what happens" is nothing. Did you mean to post 30° - 35° Which also pastes with no changes. Gord On Tue, 14 Apr 2009 15:32:01 -0700, Sheeloo just remove all As... wrote: Gord, Try to copy the values posted by Crissy (excluding the quotes) and paste in any cell... you will see what happens... I suspect it is due to the code of the degree symbol being inserted (not the one I inserted successfully)... I am not sure why but I could replicate what by copying and pasting... I have copied it below 30? ~35? "Gord Dibben" wrote: You are inserting the symbol in the appropriate spoot in the formula bar after hitting F2 to edit? Should work OK. Have you checked your Autocorrect list for entries that would change 35° degrees to 53°? What happens if you just enter 35 then insert a symbol or type 35 then Alt + 0176 on the Numpad? Gord Dibben MS Excel MVP On Tue, 14 Apr 2009 13:44:01 -0700, Crissy wrote: Sorry Im just learning how to use this web site. To put the degree symbol in am going to "Insert Symbol" and then inserting it to the text. The excel version that I am using is Microsoft Office Excel 2003. "Sheeloo" wrote: As I asked yesterday, how are you inputting the symbols (degree symbol)? Excel version? "Crissy" wrote: I am trying to put in a cell "30? ~35? " but when I do it switches the 35? to 53?. I have tried the cell format on "general" and "text" as well as the "number" but they all do this. Why is it doing this and how can I stop it? |
#9
|
|||
|
|||
Symbols
On Tue, 14 Apr 2009 13:44:01 -0700, Crissy
wrote: Sorry Im just learning how to use this web site. To put the degree symbol in am going to "Insert Symbol" and then inserting it to the text. The excel version that I am using is Microsoft Office Excel 2003. There's something very odd about your data. When I paste from the web version of this NG into Excel 2007, I see the same problem as you do. But it seems as if it is a display problem. 1. Your degree sign does not look the same as mine. The circle is smaller, and the line is "thinner" 2. If I edit within the cell, the cursor moves in a peculiar fashion. I don't have a "degree symbol" under Insert/Special characters. It seems there is something "special" about whatever degree symbol it is that you are using, that messes up the display. I would suggest entering your data as follows: Select the cell. Enter the following key strokes: But note that when I write alt0176 that means to hold down the alt key while holding down the alt key, sequentially type 0176 on the ***numeric keypad*** (not on the numbers above the regular keyboard). -------------------- 3 0 alt0176 ~ 5 3 alt0176 ----------------------- --ron |
Thread Tools | |
Display Modes | |
|
|