[急求]如何将日期变成大写,转账支票上用的~
发布网友
发布时间：2022-04-23 10:13
共1个回答
热心网友
时间：2023-10-11 03:06
A2=text(year(a1),"[dbnum2]")
A3=right(text(month(a1)+100,"[dbnum2]"),2)
A4=MID(TEXT(DAY(A1)+100,"[dbnum2]"),FIND("佰",TEXT(DAY(A1)+100,"[dbnum2]"),1)+1,LEN(TEXT(DAY(A1)+100,"[dbnum2]"))-FIND("佰",TEXT(DAY(A1)+100,"[dbnum2]"),1))追问我稍微改了一下，妥妥的了，你这想法不错，谢谢！
A2=TEXT(A1*1,"[DbNum2]yyyy")
