如何把46个月换算成*年*个月

大猴子和小老鼠

=ROUNDDOWN(P4/12,0)&"年"&P4-ROUNDDOWN(P4/12,0)*12&"个月"

韩和国

=SUBSTITUTE(TEXT(SUBSTITUTE(P4,"个月",)/12,"0年0个月/12"),"/12",)

垻垻

=INT(SUBSTITUTE(P4,"个月",)/12)&"年"&MOD(SUBSTITUTE(P4,"个月",),12)&"个月"

活好自已

=INT(SUBSTITUTE(46,"个月","")/12)&"年"&MOD(SUBSTITUTE(46,"个月",""),12)&"个月"

行云听风

=TEXT(DOLLARFR(LEFT(O4,LEN(O4)-2)/12,12)/1%,"0年00个月")

漂流的冰凌

我只想问问，你楼层里的背景咋弄的？

麻春宝

=INT(SUBSTITUTE(P4,"个月",)/12)&"年"&MOD(SUBSTITUTE(P4,"个月",),12)&"个月"

专家说我骚

回复可以设置背景色喔

烟酉

=INT(SUBSTITUTE(P4,"个月",)/12)&"年"&MOD(SUBSTITUTE(P4,"个月",),12)&"个月"

韩喜春

=INT(SUBSTITUTE(46,"个月","")/12)&"年"&MOD(SUBSTITUTE(46,"个月",""),12)&"个月"