<table style="width:100%; border:none; border-spacing:0px;"> <tr style="text-align:left;vertical-align:middle;"> <td style="vertical-align:middle; height:35px; background-color:#6ab5ff; padding:0px;"><p><span style="font-size: 14pt; font-weight: bold; color: #ffffff;"> &nbsp;功能名称</span></p> </td> </tr> <tr style="text-align:left;vertical-align:top;"> <td style="vertical-align:top; padding:0px;"><p>&nbsp;</p> <p> &nbsp; &nbsp; &nbsp; 名称：文本数值转真正数值</p> <p> &nbsp; &nbsp; &nbsp; <img src="http://www.office-cn.net/t/exaddin/texttonumber.jpg" width="245" height="223" alt="TextToNumber" style="border:none" /></p> </td> </tr> <tr style="text-align:left;vertical-align:top;"> <td style="vertical-align:top; padding:0px;"><br /> </td> </tr> <tr style="text-align:left;vertical-align:middle;"> <td style="vertical-align:middle; height:35px; background-color:#6ab5ff; padding:0px;"><p><span style="font-size: 14pt; font-weight: bold; color: #ffffff;"> &nbsp;功能描述</span></p> </td> </tr> <tr style="text-align:left;vertical-align:top;"> <td style="vertical-align:top; padding:0px;"><p>&nbsp;</p> <p> &nbsp; &nbsp; &nbsp; 该功能是将文本型数值转换为真正的数值</p> </td> </tr> <tr style="text-align:left;vertical-align:top;"> <td style="vertical-align:top; padding:0px;"><br /> </td> </tr> <tr style="text-align:left;vertical-align:middle;"> <td style="vertical-align:middle; height:35px; background-color:#6ab5ff; padding:0px;"><p><span style="font-size: 14pt; font-weight: bold; color: #ffffff;"> &nbsp;使用帮助</span></p> </td> </tr> <tr style="text-align:left;vertical-align:top;"> <td style="vertical-align:top; padding:0px;"><p>&nbsp;</p> <p> &nbsp; &nbsp; &nbsp; <span style="font-size: 12pt; font-weight: bold;">GIF动画演示</span>：</p> <p> &nbsp; &nbsp; &nbsp; <img src="http://www.office-cn.net/t/exaddin/06.gif" width="811" height="619" alt="06" style="border:none" /></p> <p>&nbsp;</p> <p> &nbsp; &nbsp; &nbsp; 一般文本型数字有两种：前面带单引号的数字 和 单元格格式是文本的数字。</p> <p>&nbsp;</p> <p> &nbsp; &nbsp; &nbsp; 使用步骤：</p> <p> &nbsp; &nbsp; &nbsp; 1、选中要转换的单元格；</p> <p> &nbsp; &nbsp; &nbsp; 2、点击菜单：数值转换 --&gt; 文本数值转真正数值 &nbsp;即可。</p> <p>&nbsp;</p> <p> &nbsp; &nbsp; &nbsp; <span style="font-size: 12pt; font-weight: bold;">例如：有这么一些数值要转换</span></p> <p> &nbsp; &nbsp; &nbsp; <img src="http://www.office-cn.net/t/exaddin/texttonumber_data.jpg" width="319" height="167" alt="TextToNumber_Data" style="border:none" /></p> <p>&nbsp;</p> <p> &nbsp; &nbsp; &nbsp; 选中 A1:B4，点击“<span style="font-weight: bold;">文本数值转真正数值</span>”菜单。</p> <p> &nbsp; &nbsp; &nbsp; <img src="http://www.office-cn.net/t/exaddin/texttonumber_select.jpg" width="349" height="244" alt="TextToNumber_Select" style="border:none" /></p> <p> &nbsp; &nbsp; &nbsp; </p> <p> &nbsp; &nbsp; &nbsp; 转换得到真正的数值，结果如下：</p> <p> &nbsp; &nbsp; &nbsp; <img src="http://www.office-cn.net/t/exaddin/texttonumber_result.jpg" width="329" height="120" alt="TextToNumber_Result" style="border:none" /></p> <p>&nbsp;</p> <p> &nbsp; &nbsp; &nbsp; <span style="font-size: 12pt; font-weight: bold;">注意，以下两种情况是不会执行转换。</span></p> <p> &nbsp; &nbsp; &nbsp; 1、非数字；</p> <p> &nbsp; &nbsp; &nbsp; 2、公式。</p> </td> </tr> <tr style="text-align:left;vertical-align:top;"> <td style="vertical-align:top; padding:0px;"><br /> </td> </tr> </table>