Question

如何在EXCLE中把数字转换成中文大写（267变为零零贰陆柒这样）

要求5位数，无万仟佰拾
例如：1017--零壹零壹柒，267--零零贰陆柒。
选取[单元格格式],在[数字]选项下,有[特殊]下有中文大写的转换”这样得到的是“壹仟零壹拾柒”，问题现在我要的是“零壹零壹柒”，用在打印发票上的填充。

Answer 1

=IF(LEFT(G38,1)="0","零",CHOOSE(LEFT(G38,1),"壹","贰","叁","肆","伍","陆","柒","扒","玖",))&IF(MID(G38,2,1)="0","零",CHOOSE(MID(G38,2,1),"壹","贰","叁","肆","伍","陆","柒","扒","玖",))&IF(MID(G38,3,1)="0","零",CHOOSE(MID(G38,3,1),"壹","贰","叁","肆","伍","陆","柒","扒","玖",))&IF(MID(G38,4,1)="0","零",CHOOSE(MID(G38,4,1),"壹","贰","叁","肆","伍","陆","柒","扒","玖",))&IF(MID(G38,5,1)="0","零",CHOOSE(MID(G38,5,1),"壹","贰","叁","肆","伍","陆","柒","扒","玖",))

我是在G38填数做试验的，你可以将“G38”改成你要转的五位数的单元格地址

但你一定要把“G38”改成“文本格式”，并要输入五位的数字，否则会提示出错，例如你要输入267,请在G38里输入“00267”，应该输入267也行，不过可能公式更烦了，希望能帮到你，本人水平有限！

下面有附图，加点分了，我也想了差不多一个小时了，谢谢

Answer 2

选取[单元格格式],在[数字]选项下,有[特殊]下有中文大写的转换

Answer 3

=numberstring(1017)