View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
FLKulchar FLKulchar is offline
external usenet poster
 
Posts: 80
Default Reading Only Numeric Value of Cell

"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
"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
Select and EditReplace

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

On Tue, 8 Apr 2008 12:53:00 -0700, F. Lawrence Kulchar
wrote:

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