
A) Use the indoor temperature as the example. Go into to a new cell (for example, N3), type
“=VALUE(SUBSTITUTE(B3,”,”,”.”))” . Then an Excel readable indoor temperature reading is created
B) Then we copy this formula to all cells in column N. A set of valid indoor temperature readings are
ready for graph plotting