Question

excel单元格中大写金额前面怎样自动加“人民币”？

首先谢谢大家！我是自动生成大写金额的单元格，采用你们的方法都不行。该单元格的函数是：=SUBSTITUTE(SUBSTITUTE(IF(D4<0,"负","")&TEXT(TRUNC(ABS(ROUND(D4,2))),"[DBNum2]")&"元"&IF(ISERR(FIND(".",ROUND(D4,2))),"",TEXT(RIGHT(TRUNC(ROUND(D4,2)*10)),"[DBNum2]"))&IF(ISERR(FIND(".0",TEXT(D4,"0.00"))),"角","")&IF(LEFT(RIGHT(ROUND(D4,2),3))=".",TEXT(RIGHT(ROUND(D4,2)),"[DBNum2]")&"分",IF(ROUND(D4,2)=0,"","整")),"零元零",""),"零元","零")

Answer 1

右键编辑单元格格式--数字--自定义---类型选择＿￥＊＃＃＃.0等等并将￥改写成人民币就行了

Answer 2

选择该列--右键--设置单元格格式--自定义
在右边"类型"框中输入:"人民币"#
确定退出即可

Answer 3

单元格格式 自定义

追问

详细点嘛