Hello, I have a column with numbers and I want to cut off the first two before the decimal. The only problem is some have one number before the decimal or no decimal at all. Any thoughts on how to work the Left formula or a better one this way?
<table border="0" cellpadding="0" cellspacing="0" height="246" width="322"><colgroup><col style="width:49pt" width="66"> <col style="mso-width-source:userset;mso-width-alt:4238;width:89pt" width="119"> </colgroup><tbody><tr style="height:14.4pt" height="19"> <td class="xl101" style="height:14.4pt;width:49pt" height="19" width="66">Column A</td> <td class="xl101" style="width:89pt" width="119">Column B</td> </tr> <tr style="height:14.4pt" height="19"> <td class="xl103" style="height:14.4pt" height="19">Data Set</td> <td class="xl101">Desired OUTPUT</td> </tr> <tr style="height:14.4pt" height="19"> <td class="xl103" style="height:14.4pt;border-top:none" height="19">9.4</td> <td class="xl104" align="left">9</td> </tr> <tr style="height:14.4pt" height="19"> <td class="xl103" style="height:14.4pt;border-top:none" height="19">5.1.2</td> <td class="xl104" align="left">5</td> </tr> <tr style="height:14.4pt" height="19"> <td class="xl103" style="height:14.4pt;border-top:none" height="19">5.1.2</td> <td class="xl104" align="left">5</td> </tr> <tr style="height:14.4pt" height="19"> <td class="xl102" style="height:14.4pt" height="19">30</td> <td class="xl104" align="left">30</td> </tr> <tr style="height:14.4pt" height="19"> <td class="xl102" style="height:14.4pt" height="19">60</td> <td class="xl104" align="left">60</td> </tr> <tr style="height:14.4pt" height="19"> <td class="xl102" style="height:14.4pt" height="19">1.1.1</td> <td class="xl104" align="left">1</td> </tr> <tr style="height:14.4pt" height="19"> <td class="xl102" style="height:14.4pt" height="19">10.1.2</td> <td class="xl104" align="left">10</td> </tr> <tr style="height:14.4pt" height="19"> <td class="xl102" style="height:14.4pt" height="19">12.1</td> <td class="xl104" align="left">12</td> </tr> </tbody></table>
<table border="0" cellpadding="0" cellspacing="0" height="246" width="322"><colgroup><col style="width:49pt" width="66"> <col style="mso-width-source:userset;mso-width-alt:4238;width:89pt" width="119"> </colgroup><tbody><tr style="height:14.4pt" height="19"> <td class="xl101" style="height:14.4pt;width:49pt" height="19" width="66">Column A</td> <td class="xl101" style="width:89pt" width="119">Column B</td> </tr> <tr style="height:14.4pt" height="19"> <td class="xl103" style="height:14.4pt" height="19">Data Set</td> <td class="xl101">Desired OUTPUT</td> </tr> <tr style="height:14.4pt" height="19"> <td class="xl103" style="height:14.4pt;border-top:none" height="19">9.4</td> <td class="xl104" align="left">9</td> </tr> <tr style="height:14.4pt" height="19"> <td class="xl103" style="height:14.4pt;border-top:none" height="19">5.1.2</td> <td class="xl104" align="left">5</td> </tr> <tr style="height:14.4pt" height="19"> <td class="xl103" style="height:14.4pt;border-top:none" height="19">5.1.2</td> <td class="xl104" align="left">5</td> </tr> <tr style="height:14.4pt" height="19"> <td class="xl102" style="height:14.4pt" height="19">30</td> <td class="xl104" align="left">30</td> </tr> <tr style="height:14.4pt" height="19"> <td class="xl102" style="height:14.4pt" height="19">60</td> <td class="xl104" align="left">60</td> </tr> <tr style="height:14.4pt" height="19"> <td class="xl102" style="height:14.4pt" height="19">1.1.1</td> <td class="xl104" align="left">1</td> </tr> <tr style="height:14.4pt" height="19"> <td class="xl102" style="height:14.4pt" height="19">10.1.2</td> <td class="xl104" align="left">10</td> </tr> <tr style="height:14.4pt" height="19"> <td class="xl102" style="height:14.4pt" height="19">12.1</td> <td class="xl104" align="left">12</td> </tr> </tbody></table>