excel中文大写 转换 阿拉伯数字答:SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,"壹","1"),"贰","2"),"叁","3"),"肆","4"),"伍","5"),"陆","6"),"柒","7"),"捌","8")C1=SUBSTITUTE(B1,"玖","9")因为EXCEL公式只允许7次嵌套,所以分两步完成,这个方法的缺点就是被转换数字不能包含零,...
易语言 中文 英文 数字转换为数字答:' 英文转为数字 字符 = 多项选择 (计数, “one”, “two”, “three”, “four”, “five”, “six”, “seven”, “eight”, “nine”, “zero”)数字 = 多项选择 (计数, “1”, “2”, “3”, “4”, “5”, “6”, “7”, “8”, “9”, “0”)数据 = 子文本...