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?