Foxtable(狐表)用户栏目专家坐堂 → [求助]求助有点色老师关于WORD模板 急!


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

主题:[求助]求助有点色老师关于WORD模板 急!

帅哥哟,离线,有人找我吗?
有点色
  1楼 | 信息 | 搜索 | 邮箱 | 主页 | UC


加好友 发短信
等级:超级版主 帖子:13837 积分:69650 威望:0 精华:0 注册:2016/11/1 14:42:00
  发帖心情 Post By:2017/5/11 20:27:00 [显示全部帖子]

用下面的代码测试

 

dim str = Replace(Replace(Replace(Replace(CUNumber(21),"壹","一"), "拾", "十"), "贰", "二"), "叁", "三")
msgbox(str)


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


加好友 发短信
等级:超级版主 帖子:13837 积分:69650 威望:0 精华:0 注册:2016/11/1 14:42:00
  发帖心情 Post By:2017/5/11 22:08:00 [显示全部帖子]

请灵活变通,比如

 

<Replace(Replace(Replace(Replace(CUNumber([序号]),"壹","一"), "拾", "十"), "贰", "二"), "叁", "三")>


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


加好友 发短信
等级:超级版主 帖子:13837 积分:69650 威望:0 精华:0 注册:2016/11/1 14:42:00
  发帖心情 Post By:2017/5/11 23:38:00 [显示全部帖子]

看懂下面代码

 

dim i as integer = 54
Dim str = iif(i=10, "十", iif(i>10 and i<20, right(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(CUNumber(i),"壹","一"), "拾", "十"), "贰", "二"), "叁", "三"), "肆", "四"), "伍", "五"), "陆", "六"), "柒", "七"), "捌", "八"), "玖", "九"),2), Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(CUNumber(i),"壹","一"), "拾", "十"), "贰", "二"), "叁", "三"), "肆", "四"), "伍", "五"), "陆", "六"), "柒", "七"), "捌", "八"), "玖", "九")))
msgbox(str)


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


加好友 发短信
等级:超级版主 帖子:13837 积分:69650 威望:0 精华:0 注册:2016/11/1 14:42:00
  发帖心情 Post By:2017/5/12 9:02:00 [显示全部帖子]

<iif([序号]=10, "十", iif([序号]>10 And [序号]<20, right(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(CUNumber([序号]),"壹","一"), "拾", "十"), "贰", "二"), "叁", "三"), "肆", "四"), "伍", "五"), "陆", "六"), "柒", "七"), "捌", "八"), "玖", "九"),2), Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(CUNumber([序号]),"壹","一"), "拾", "十"), "贰", "二"), "叁", "三"), "肆", "四"), "伍", "五"), "陆", "六"), "柒", "七"), "捌", "八"), "玖", "九")))>

 回到顶部