Formating numbers with symbol in a data in excel

[ochysam]

I need urgent help! Can someone pls show me how to format a cell in excel with less than symbol on the number in a group of data in a column? I need to find the median, max value and min values but the cells with < is affecting my calculation.
My numbers are arranged like this
<table width="64" border="0" cellpadding="0" cellspacing="0"><col style="width: 48pt;" width="64"> <tbody><tr style="height: 15pt;" align="center" height="20"> <td class="xl63" style="height: 15pt; width: 48pt;" width="64" height="20">0.009</td> </tr> <tr style="height: 15pt;" align="center" height="20"> <td class="xl63" style="height: 15pt;" height="20">0.005</td> </tr> <tr style="height: 15pt;" align="center" height="20"> <td class="xl63" style="height: 15pt;" height="20">0.003</td> </tr> <tr style="height: 15pt;" align="center" height="20"> <td class="xl63" style="height: 15pt;" height="20"><0.001</td> </tr> <tr style="height: 15pt;" align="center" height="20"> <td class="xl63" style="height: 15pt;" height="20">0.003</td> </tr> <tr style="height: 15pt;" align="center" height="20"> <td class="xl63" style="height: 15pt;" height="20">0.003</td> </tr> <tr style="height: 15pt;" align="center" height="20"> <td class="xl63" style="height: 15pt;" height="20">0.014</td> </tr> <tr style="height: 15pt;" align="center" height="20"> <td class="xl63" style="height: 15pt;" height="20"><0.001</td> </tr> <tr style="height: 15pt;" align="center" height="20"> <td class="xl63" style="height: 15pt;" height="20">0.004</td> </tr> <tr style="height: 15pt;" align="center" height="20"> <td class="xl63" style="height: 15pt;" height="20">0.003</td> </tr> <tr style="height: 15pt;" align="center" height="20"> <td class="xl63" style="height: 15pt;" height="20">0.005</td> </tr> <tr style="height: 15pt;" align="center" height="20"> <td class="xl63" style="height: 15pt;" height="20">0.005</td> </tr> <tr style="height: 15pt;" align="center" height="20"> <td class="xl63" style="height: 15pt;" height="20">0.003</td> </tr> <tr style="height: 15pt;" align="center" height="20"> <td class="xl63" style="height: 15pt;" height="20">0.004</td> </tr> <tr style="height: 15pt;" align="center" height="20"> <td class="xl63" style="height: 15pt;" height="20"><0.001</td> </tr> <tr style="height: 15pt;" align="center" height="20"> <td class="xl63" style="height: 15pt;" height="20">0.009</td> </tr> <tr style="height: 15pt;" align="center" height="20"> <td class="xl63" style="height: 15pt;" height="20">0.007</td> </tr> <tr style="height: 15pt;" align="center" height="20"> <td class="xl63" style="height: 15pt;" height="20">0.004</td> </tr> <tr style="height: 15pt;" align="center" height="20"> <td class="xl63" style="height: 15pt;" height="20"><0.004</td> </tr> <tr style="height: 15pt;" align="center" height="20"> <td class="xl63" style="height: 15pt;" height="20">0.002</td> </tr> <tr style="height: 15pt;" align="center" height="20"> <td class="xl63" style="height: 15pt;" height="20">0.003</td> </tr> <tr style="height: 15pt;" align="center" height="20"> <td class="xl63" style="height: 15pt;" height="20">0.008</td> </tr> <tr style="height: 15pt;" align="center" height="20"> <td class="xl63" style="height: 15pt;" height="20">0.006</td> </tr> <tr style="height: 15pt;" align="center" height="20"> <td class="xl63" style="height: 15pt;" height="20">0.004</td> </tr> <tr style="height: 15pt;" align="center" height="20"> <td class="xl63" style="height: 15pt;" height="20">0.009</td> </tr> <tr style="height: 15pt;" align="center" height="20"> <td class="xl63" style="height: 15pt;" height="20"><0.001</td> </tr> </tbody></table>
Thanks

 

[Joe4]

Why not remove the less than with a Search and Replace (replace less than sign with nothing)?