Excel怎么把小写数字变成大写

发布网友 发布时间：2022-04-20 02:35

我来回答

共2个回答

热心网友 时间：2022-05-23 15:29

=IF(A1=0,"",CONCATENATE(IF(INT(ABS(A1))=0,"",TEXT(INT(ABS(A1)),"[DBNum2]G/通用格式")),IF(INT(MID(RIGHT(FIXED(ABS(A1),2,1),2),1,1))=0,IF(INT(MID(RIGHT(FIXED(A1,2,1),1),1,1))=0,"",IF(INT(ABS(A1))=0,"","零")),TEXT(INT(MID(RIGHT(FIXED(A1,2,1),2),1,1)),"[DBNum2]G/通用格式")),IF(INT(MID(RIGHT(FIXED(A1,2,1),1),1,1))=0,"",TEXT(INT(MID(RIGHT(FIXED(A1,2,1),1),1,1)),"[DBNum2]G/通用格式"))))
-------
完整公式
=IF(A1=0,"",CONCATENATE(IF(INT(ABS(A1))=0,"",TEXT(INT(ABS(A1)),"[DBNum2]G/通用格式元")),IF(INT(MID(RIGHT(FIXED(ABS(A1),2,1),2),1,1))=0,IF(INT(MID(RIGHT(FIXED(A1,2,1),1),1,1))=0,"",IF(INT(ABS(A1))=0,"","零")),TEXT(INT(MID(RIGHT(FIXED(A1,2,1),2),1,1)),"[DBNum2]G/通用格式角")),IF(INT(MID(RIGHT(FIXED(A1,2,1),1),1,1))=0,"整",TEXT(INT(MID(RIGHT(FIXED(A1,2,1),1),1,1)),"[DBNum2]G/通用格式分"))))

热心网友 时间：2022-05-23 15:30

a1 输入20100608，中间不要有空格。

=TEXT(A1,"[DBNum2]0000 00 00")
=TEXT(TEXT(A1,"0000-00-00"),"[DBNum2]yyyy mm dd")

两个挑一个，后者应更符合习惯。