数据源
5.68434E-14
0.749737013
24.12262227
26.98775967
现在要想将5.68434E-14去掉
为什么用下式不成立
Sql = "Select distinct abs(lineStartPoint0 - lineEndPoint0) " & _
"from [Line$] Where Layer = '粗实线' and int(lineStartPoint0 - lineEndPoint0) <> 0 "
5.68434E-14
0.749737013
24.12262227
26.98775967
现在要想将5.68434E-14去掉
为什么用下式不成立
Sql = "Select distinct abs(lineStartPoint0 - lineEndPoint0) " & _
"from [Line$] Where Layer = '粗实线' and int(lineStartPoint0 - lineEndPoint0) <> 0 "
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货