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?