<p>这个题第一我没看懂,第2不知道怎么筛选出所有尾数是数字或字母。没找到解答,希望高手解答下。</p><p>虚心请教! <table cellspacing="0" cellpadding="0" width="637" border="0" xstr="" style="WIDTH: 477pt; BORDER-COLLAPSE: collapse;"><colgroup><col span="3" width="72" style="WIDTH: 54pt;"></col><col width="92" style="WIDTH: 69pt; mso-width-source: userset; mso-width-alt: 2944;"></col><col span="2" width="87" style="WIDTH: 65pt; mso-width-source: userset; mso-width-alt: 2784;"></col><col width="72" style="WIDTH: 54pt;"></col><col width="83" style="WIDTH: 62pt; mso-width-source: userset; mso-width-alt: 2656;"></col></colgroup><tbody><tr height="22" style="HEIGHT: 16.5pt;"><td class="xl22" width="637" colspan="8" height="22" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: green 1pt dashed; WIDTH: 477pt; BORDER-BOTTOM: #ece9d8; HEIGHT: 16.5pt; BACKGROUND-COLOR: #ffff99; mso-ignore: colspan;"><font face="MingLiU" color="#ff0000">三、在情况一中设置公式,求出书号对应单元格最后一位是否不为数值,以方便筛选。</font></td></tr></tbody></table></p><br/>
[此贴子已经被作者于2007-8-1 17:22:59编辑过] |