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
|