1、魔方网表中如何把数字日期格式转中文日期格式？公式如下：CHOOSE(MID(TEXT($MF(日期)$,"yyyy"),1,1)+1,"○","一","二","三","四","五","六","七","八","九")&CHOOSE(MID(TEXT($MF(日期)$,"yyyy"),2,1)+1,"○","一","二","三","四","五","六","七","八","九")&CHOOSE(MID(TEXT($MF(日期)$,"yyyy"),3,1)+1,"○","一","二","三","四","五","六","七","八","九")&CHOOSE(MID(TEXT($MF(日期)$,"yyyy"),4,1)+1,"○","一","二","三","四","五","六","七","八","九")&"年"&CHOOSE(TEXT($MF(日期)$,"MM")+0,"一","二","三","四","五","六","七","八","九","十","十一","十二")&"月"&IF(TEXT($MF(日期)$,"dd")+0 < 16,CHOOSE(TEXT($MF(日期)$,"dd")+0,"一","二","三","四","五","六","七","八","九","十","十一","十二","十三","十四","十五"),CHOOSE(TEXT($MF(日期)$,"dd")-15,"十六","十七","十八","十九","二十","二十一","二十二","二十三","二十四","二十五","二十六","二十七","二十八","二十九","三十","三十一"))&"日" $MF(日期)$指数字日期字段,可以在一个文本字段中启用上述公式存储转换后的中文日期。
2、数字类型，转换千分位数字格式 如果想要在魔方中显示千分位格式的数据，那么一定要选择这个方法，非常简单，一个小小的公式就能搞定行间公式：TEXT($MF(金额)$,"#,##0.00")
3、公式中如何使用每天的固定时间比如每天上午9点：TEXT(NOW(), "yyyy-MM-dd") & " 09:00:00"
4、身份证号1、通过身份证号判断性别：IF(MOD(MID($MF(身份证号)$,17,1),2)=1,"男","女")2、通过身份证号计算出生日期：MID($MF(身份证号)$,7,4)&"年"&MID($MF(身份证号)$,12,2)&"月"&MID($MF(身份证号)$,13,2)&"日"3、通过身份证号计算年龄：text(year(today())-MID($MF(身份证号)$,7,4),0)想了解更多相关审核证号的应用，可以参考：有关身份证号码处理的一个实例介绍（附模板）http://bbs.mf999.com/forum.php?mod=viewthread&tid=5060&highlight=%C9%ED%B7%DD%D6%A4
5、怎么实现英文的大小写转换LOWER()函数：大写字母转换为小写字母。 例如：$MF(文本1)$=ABC；$MF(文本2)$=App.123 LOWER($MF(文本)$)=abc LOWER($MF(文本)$)=app.123 UPPER()函数：小写字母转换为大写字母。 例如：$MF(文本1)$=abc；$MF(文本2)$=App.123 LOWER($MF(文本)$)=ABC LOWER($MF(文本)$)=APP.123
6、由小写数据转换成财务的大写“元”、“角”、“分”IF(left(MFCNUM($MF(金额)$),1)="拾","壹"&SUBSTITUTE(SUBSTITUTE(MFCNUM(INT($MF(金额)$))&"元"&MFCNUM(INT(ROUND($MF(金额)$,2)*10)-INT(ROUND($MF(金额)$,2))*10)&"角"&MFCNUM(INT(ROUND($MF(金额)$,2)*100)-INT(ROUND($MF(金额)$,2)*10)*10)&"分","零角零分","整"),"零分","整"),SUBSTITUTE(SUBSTITUTE(MFCNUM(INT($MF(金额)$))&"元"&MFCNUM(INT(ROUND($MF(金额)$,2)*10)-INT(ROUND($MF(金额)$,2))*10)&"角"&MFCNUM(INT(ROUND($MF(金额)$,2)*100)-INT(ROUND($MF(金额)$,2)*10)*10)&"分","零角零分","整"),"零分","整"))
7、文本日期格式 "1993年8月1日" 转换为 "19930801”需要新建3个字段，分别编辑计算公式。日期格式2的计算公式：if(mid($MF(日期格式1)$,7,1)="月",left($MF(日期格式1)$,5)&"0"&mid($MF(日期格式1)$,6,5),left($MF(日期格式1)$,11))日期格式3的计算公式：if(mid($MF(日期格式2)$,10,1)="日",left($MF(日期格式2)$,8)&"0"&mid($MF(日期格式2)$,9,2),left($MF(日期格式2)$,11))日期格式4的计算公式：SUBSTITUTE(SUBSTITUTE(SUBSTITUTE($MF(日期格式3)$,"年",""),"月",""),"日","")新增一个字段，编辑计算公式：日期格式5的计算公式：SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(if(mid(if(mid($MF(日期格式1)$,7,1)="月",left($MF(日期格式1)$,5)&"0"&mid($MF(日期格式1)$,6,4),left($MF(日期格式1)$,10)),10,1)="日",left(if(mid($MF(日期格式1)$,7,1)="月",left($MF(日期格式1)$,5)&"0"&mid($MF(日期格式1)$,6,4),left($MF(日期格式1)$,10)),8)&"0"&right($MF(日期格式1)$,2),if(mid($MF(日期格式1)$,7,1)="月",left($MF(日期格式1)$,5)&"0"&mid($MF(日期格式1)$,6,5),left($MF(日期格式1)$,11))),"年",""),"月",""),"日","")
8、怎么将“01234”转换为"O一二三四"此处只转换前5位。if(mid($MF(A1)$,1,1)="1","一",if(mid($MF(A1)$,1,1)="2","二",if(mid($MF(A1)$,1,1)="3","三",if(mid($MF(A1)$,1,1)="4","四",if(mid($MF(A1)$,1,1)="5","五",if(mid($MF(A1)$,1,1)="6","六",if(mid($MF(A1)$,1,1)="7","七",if(mid($MF(A1)$,1,1)="8","八",if(mid($MF(A1)$,1,1)="9","九",if(mid($MF(A1)$,1,1)="0","〇"))))))))))&if(mid($MF(A1)$,2,1)="1","一",if(mid($MF(A1)$,2,1)="2","二",if(mid($MF(A1)$,2,1)="3","三",if(mid($MF(A1)$,2,1)="4","四",if(mid($MF(A1)$,2,1)="5","五",if(mid($MF(A1)$,2,1)="6","六",if(mid($MF(A1)$,2,1)="7","七",if(mid($MF(A1)$,2,1)="8","八",if(mid($MF(A1)$,2,1)="9","九",if(mid($MF(A1)$,2,1)="0","〇"))))))))))&if(mid($MF(A1)$,3,1)="1","一",if(mid($MF(A1)$,3,1)="2","二",if(mid($MF(A1)$,3,1)="3","三",if(mid($MF(A1)$,3,1)="4","四",if(mid($MF(A1)$,3,1)="5","五",if(mid($MF(A1)$,3,1)="6","六",if(mid($MF(A1)$,3,1)="7","七",if(mid($MF(A1)$,3,1)="8","八",if(mid($MF(A1)$,3,1)="9","九",if(mid($MF(A1)$,3,1)="0","〇"))))))))))&if(mid($MF(A1)$,4,1)="1","一",if(mid($MF(A1)$,4,1)="2","二",if(mid($MF(A1)$,4,1)="3","三",if(mid($MF(A1)$,4,1)="4","四",if(mid($MF(A1)$,4,1)="5","五",if(mid($MF(A1)$,4,1)="6","六",if(mid($MF(A1)$,4,1)="7","七",if(mid($MF(A1)$,4,1)="8","八",if(mid($MF(A1)$,4,1)="9","九",if(mid($MF(A1)$,4,1)="0","〇"))))))))))&if(mid($MF(A1)$,5,1)="1","一",if(mid($MF(A1)$,5,1)="2","二",if(mid($MF(A1)$,5,1)="3","三",if(mid($MF(A1)$,5,1)="4","四",if(mid($MF(A1)$,5,1)="5","五",if(mid($MF(A1)$,5,1)="6","六",if(mid($MF(A1)$,5,1)="7","七",if(mid($MF(A1)$,5,1)="8","八",if(mid($MF(A1)$,5,1)="9","九",if(mid($MF(A1)$,5,1)="0","〇"))))))))))