Reading Only Numeric Value of Cell

[F. Lawrence Kulchar]

I am copying data from the internet which includes the "degree" value
inputted into my excel spreadsheet...in other words, my value in the cell
says...123 degrees, with degrees as the tiny circle.

How can I read the cell without the degree sign???

Thanks,

FLKulchar

 

[Gord Dibben]

Select and Edit>Replace

What: hold Alt key and enter 0186 from the num pad

With: nothing

Note, it could be a different ascii number but 0186 would be most common.


Gord Dibben MS Excel MVP

 

[FLKulchar]

tHANK YOU


very fine response..IT WORKS!!

flkULCHAR

 

[FLKulchar]

RE: "0186"...

I am not sure what you mean here, but I cannot seem to make your response
work for me; anny more input??

Thanks,

FLKulchar

 

[Dave Peterson]

Select an empty cell
hit and hold the alt-key while you type: 0186 on the number pad

You'll see that degree symbol in the cell.

Now select that symbol in the formula bar and hit ctrl-c.

Then show the edit|Replace dialog and use ctrl-v to paste that symbol into the
"Find What" box.