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?