易表在线答疑技术与交流用户社区 → 导出数据无小数位后的数字


  共有6170人关注过本帖树形打印复制链接

主题:导出数据无小数位后的数字

美女呀,离线,留言给我吧!
zmdb
  1楼 | 信息 | 搜索 | 邮箱 | 主页 | UC


加好友 发短信
等级:论坛游民 帖子:105 积分:187 威望:0 精华:0 注册:2006/11/7 13:16:00
导出数据无小数位后的数字  发帖心情 Post By:2017/7/12 13:20:00 [只看该作者]

以前都好好的,突然从易表中导成的EXCEL文件金额中缺少了小数位后面的数字,如:原本应该导出13.11,而错误的导成了13

 回到顶部
美女呀,离线,留言给我吧!
zmdb
  2楼 | 信息 | 搜索 | 邮箱 | 主页 | UC


加好友 发短信
等级:论坛游民 帖子:105 积分:187 威望:0 精华:0 注册:2006/11/7 13:16:00
  发帖心情 Post By:2017/7/12 13:51:00 [只看该作者]

在线等啊~请各位帮助解决下问题吧!

 回到顶部
帅哥哟,离线,有人找我吗?
iyplx2425
  3楼 | 信息 | 搜索 | 邮箱 | 主页 | UC


加好友 发短信
等级:蒙面侠 帖子:2494 积分:6748 威望:0 精华:0 注册:2011/3/30 12:48:00
  发帖心情 Post By:2017/7/12 13:57:00 [只看该作者]

看看EXCEL单元格的设置?

 回到顶部
美女呀,离线,留言给我吧!
zmdb
  4楼 | 信息 | 搜索 | 邮箱 | 主页 | UC


加好友 发短信
等级:论坛游民 帖子:105 积分:187 威望:0 精华:0 注册:2006/11/7 13:16:00
  发帖心情 Post By:2017/7/12 14:12:00 [只看该作者]

我是在易表里设的公式导出的,以前都没问题,突然就导不出金额的小数位后数字了。
公式如下:
OpenView(1) and filterfor("区域","<>","b") and filterfor("区域","<>","g") and filterfor("区域","<>","s") and filterfor("省份","<>","十部") and movecol("发货单号",1) and movecol("经理",2) and movecol("客户编码",3) and movecol("客户名称",4) and movecol("产品名称",5) and movecol("发货数量",6) and movecol("单价",7) and movecol("金额",8) and movecol("挂账日期",9) and movecol("规格",10) and ExportDBFile("C:\Users\administrator\desktop\发货.xls",5,"2016总表","年份","=","2017","月份","=","7","区域","<>","b","区域","<>","g","区域","<>","s","省份","<>","十部","执行情况","<>","供不应求","发货单号","<>","","执行情况","<>","资信未审过","执行情况","<>","合同不合格","执行情况","<>","特批待审") and delfile("C:\Users\Administrator\desktop\发货.xls.bak") and OpenView(5) and movecol("合同号",1) and movecol("制单日期",2) and movecol("挂账日期",3) and movecol("区域",4) and movecol("省份",5) and movecol("经理",6) and movecol("执行情况",7) and movecol("发货单号",8) and movecol("客户编码",9) and movecol("客户名称",10) and movecol("收货地址",11) and movecol("邮编",12) and movecol("电话",13) and movecol("收货人",14) and movecol("运输方式",15) and movecol("铁路到站",16) and movecol("传真",17) and movecol("备注",18) and movecol("特殊说明",19) and movecol("合同原件",20) and movecol("日期",21) and movecol("月份",22) and movecol("年份",23) and movecol("刷新标记",24) and movecol("明细",25) and movecol("产品名称",26) and movecol("规格",27) and movecol("申请数量",28) and movecol("发货数量",29) and movecol("件数",30) and movecol("单价",31) and movecol("金额",32) and ShowAllRows() and do(127)

 回到顶部