excel大写金额前面自动加“人民币”
来源:学生作业帮 编辑:搜搜做题作业网作业帮 分类:综合作业 时间:2024/07/03 15:02:07
excel大写金额前面自动加“人民币”
=IF(LEFT(N10)="-",REPLACEB("-",1,1,"(负)"),"")&IF(ABS(ROUND(N10,2))
=IF(LEFT(N10)="-",REPLACEB("-",1,1,"(负)"),"")&IF(ABS(ROUND(N10,2))
![excel大写金额前面自动加“人民币”](/uploads/image/z/15841577-65-7.jpg?t=excel%E5%A4%A7%E5%86%99%E9%87%91%E9%A2%9D%E5%89%8D%E9%9D%A2%E8%87%AA%E5%8A%A8%E5%8A%A0%E2%80%9C%E4%BA%BA%E6%B0%91%E5%B8%81%E2%80%9D)
在你的公式前面加个 "人民币"& 就好了