EXCEL大写金额公式前面怎么添加“⊗”“¥”或“大写”,C1输入小写金额后,在B1显示对应带前面符号的大写金额公式怎么写,谢谢
B1:
=TEXT(C1,"[DBNum2][$RMB]G/通用格式")
B2:
="⊗"&TEXT(C2,"[DBNum2][$RMB]G/通用格式")
B3:
="¥"&TEXT(C3,"[DBNum2][$RMB]G/通用格式")
B4:
="大写:"&TEXT(C4,"[DBNum2][$RMB]G/通用格式")