WPS EXCEL帮做个公式!不是OFFICE!答:直接写一个公式会死人的,我分成两步,第一步规范为三位,公式为:=TEXT(MID(B1,1,FIND(".",B1)-1)+0,"000")&TEXT(MID(B1,FIND(".",B1)+1,FIND(".",B1,FIND(".",B1)+1)-FIND(".",B1)-1)+0,"000")&TEXT(MID(B1,FIND(".",B1,FIND(".",B1)+1)+1,FIND(".",B1,...
WPS Office (10.1.0.7106) excel如何吧阿拉伯数字转换成英文_百度知 ...答:有两种方法可以把阿拉伯数字转换成英文。一、用公式比较复杂 ="US DOLLARS "&UPPER(TRIM(IF(VALUE(RIGHT(INT(A1/1000000000),3))=0,"",LOOKUP(VALUE(LEFT(TEXT(RIGHT(INT(A1/1000000000),3),"000"),1)),{0,1,2,3,4,5,6,7,8,9;"","one","two","three","four","five","six",...