Reading Only Numeric Value of Cell
 

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

Reading Only Numeric Value of Cell
 

=LEFT(A1,LEN(A1)-1) as text
or
=--LEFT(A1,LEN(A1)-1) as a number
--
David Biddulph

"F. Lawrence Kulchar" wrote in
message ...
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

Reading Only Numeric Value of Cell
 

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

Reading Only Numeric Value of Cell
 

tHANK YOU


very fine response..IT WORKS!!

flkULCHAR
"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
=LEFT(A1,LEN(A1)-1) as text
or
=--LEFT(A1,LEN(A1)-1) as a number
--
David Biddulph

"F. Lawrence Kulchar" wrote
in message ...
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

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

Reading Only Numeric Value of Cell
 

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.




FLKulchar wrote:

"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


--

Dave Peterson