Hi!
I have data for temperature and humidity values that is fed in every half an
hour and i have to process data for 3 years so there are lots of readings.
My problem is that i have the value (26.0 °C) like this.
Now the problem is Excel won't recognise it as a number and so i can't sort
it or multiply it or whatever. Plus i have to do over say 60,000 such values.
Number formatting of the cell in any way does not help. i change the format
of the cell and it doesn't work. the cell isn't identified as having a number.
Can anyone help me on how can i change the format of the cell or anything
else to make it a numerical value?

you can do a find and replace. in the find box enter
°C
that's [space] alt+0176 C
and leave the replace field blank. click replace all and voila everything
is now a number that can be formatted how you like.

if you want to formatted to show the °C you can change the custom number
format to something like this
0.0 "°C"
this will make the cells look like 23.6 °C but still retain the numerical
value.

"Azeem!" wrote:

Hi!
I have data for temperature and humidity values that is fed in every half an
hour and i have to process data for 3 years so there are lots of readings.
My problem is that i have the value (26.0 °C) like this.
Now the problem is Excel won't recognise it as a number and so i can't sort
it or multiply it or whatever. Plus i have to do over say 60,000 such values.
Number formatting of the cell in any way does not help. i change the format
of the cell and it doesn't work. the cell isn't identified as having a number.
Can anyone help me on how can i change the format of the cell or anything
else to make it a numerical value?

Hey cud u tell me the exact way to do this?


"Sloth" wrote:

you can do a find and replace. in the find box enter
°C
that's [space] alt+0176 C
and leave the replace field blank. click replace all and voila everything
is now a number that can be formatted how you like.

if you want to formatted to show the °C you can change the custom number
format to something like this
0.0 "°C"
this will make the cells look like 23.6 °C but still retain the numerical
value.

"Azeem!" wrote:

Hi!
I have data for temperature and humidity values that is fed in every half an
hour and i have to process data for 3 years so there are lots of readings.
My problem is that i have the value (26.0 °C) like this.
Now the problem is Excel won't recognise it as a number and so i can't sort
it or multiply it or whatever. Plus i have to do over say 60,000 such values.
Number formatting of the cell in any way does not help. i change the format
of the cell and it doesn't work. the cell isn't identified as having a number.
Can anyone help me on how can i change the format of the cell or anything
else to make it a numerical value?

i put °C in the find field and left the replace with blank but it still
doesn't work. the format is till not numercal.
just kindly elaborate it.

"Azeem!" wrote:

Hey cud u tell me the exact way to do this?


"Sloth" wrote:

you can do a find and replace. in the find box enter
°C
that's [space] alt+0176 C
and leave the replace field blank. click replace all and voila everything
is now a number that can be formatted how you like.

if you want to formatted to show the °C you can change the custom number
format to something like this
0.0 "°C"
this will make the cells look like 23.6 °C but still retain the numerical
value.

"Azeem!" wrote:

Hi!
I have data for temperature and humidity values that is fed in every half an
hour and i have to process data for 3 years so there are lots of readings.
My problem is that i have the value (26.0 °C) like this.
Now the problem is Excel won't recognise it as a number and so i can't sort
it or multiply it or whatever. Plus i have to do over say 60,000 such values.
Number formatting of the cell in any way does not help. i change the format
of the cell and it doesn't work. the cell isn't identified as having a number.
Can anyone help me on how can i change the format of the cell or anything
else to make it a numerical value?

You can also insert a column to thre right of your Temp Value,
Celect the entire TempValue colum and then use text to columns feature to
split the data.


"Azeem!" wrote in message
...
Hi!
I have data for temperature and humidity values that is fed in every half
an
hour and i have to process data for 3 years so there are lots of readings.
My problem is that i have the value (26.0 °C) like this.
Now the problem is Excel won't recognise it as a number and so i can't
sort
it or multiply it or whatever. Plus i have to do over say 60,000 such
values.
Number formatting of the cell in any way does not help. i change the
format
of the cell and it doesn't work. the cell isn't identified as having a
number.
Can anyone help me on how can i change the format of the cell or anything
else to make it a numerical value?

just tell me how to do it step by step!

"DanRoss" wrote:

You can also insert a column to thre right of your Temp Value,
Celect the entire TempValue colum and then use text to columns feature to
split the data.


"Azeem!" wrote in message
...
Hi!
I have data for temperature and humidity values that is fed in every half
an
hour and i have to process data for 3 years so there are lots of readings.
My problem is that i have the value (26.0 °C) like this.
Now the problem is Excel won't recognise it as a number and so i can't
sort
it or multiply it or whatever. Plus i have to do over say 60,000 such
values.
Number formatting of the cell in any way does not help. i change the
format
of the cell and it doesn't work. the cell isn't identified as having a
number.
Can anyone help me on how can i change the format of the cell or anything
else to make it a numerical value?

Select/Highlight the row
Click Data-Text to columns
Select "Delimited" and click next
Check the box next to "space" and click next
Click Finish

This will move all of the " °C" to the next column so you can delete it.

I don't know why the find/replace method is not working for you.

Sloth just gave the exact way to do this.

If not working out for you, re-read the instructions and follow them "exactly".

If still not working then perhaps you have something else in the cells besides
what you described.


Gord Dibben MS Excel MVP

On Fri, 1 Feb 2008 09:12:01 -0800, Azeem!
wrote:

Hey cud u tell me the exact way to do this?


"Sloth" wrote:

you can do a find and replace. in the find box enter
°C
that's [space] alt+0176 C
and leave the replace field blank. click replace all and voila everything
is now a number that can be formatted how you like.

if you want to formatted to show the °C you can change the custom number
format to something like this
0.0 "°C"
this will make the cells look like 23.6 °C but still retain the numerical
value.

"Azeem!" wrote:

Hi!
I have data for temperature and humidity values that is fed in every half an
hour and i have to process data for 3 years so there are lots of readings.
My problem is that i have the value (26.0 °C) like this.
Now the problem is Excel won't recognise it as a number and so i can't sort
it or multiply it or whatever. Plus i have to do over say 60,000 such values.
Number formatting of the cell in any way does not help. i change the format
of the cell and it doesn't work. the cell isn't identified as having a number.
Can anyone help me on how can i change the format of the cell or anything
else to make it a numerical value?