www.bcmx.net > 人民币大小写在线转换

人民币大小写在线转换

假设小写金额在F2 则大写金额公式为 =text(int(F2),"[dbnum2]")&"圆"&text(--right(F2*100,2),"[dbnum2]0角0分")

="人民币大写:"&SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(TEXT(INT(A1),"[dbnum2];; ")&TEXT(MOD(A1*100,100),"[>9][dbnum2]元0角0分;[=0]元整;[dbnum2]元零0分"),"零分","整")," 元零",)," 元",)

设置E列单元格式:“数字” → “特殊” → “中文大写数字” 设置E列引用对应B列的行(设置一个单元格后,使用填充) 示例:

转账支票金额填写: 1、人民币(大写): 数字大写写法:零、壹、发叁、肆、伍、陆、柒、捌、玖、亿、万、仟、佰、拾。 注意:“万”字不带单人旁。 举例: (1)289,546.52 贰拾捌万玖仟伍佰肆拾陆元伍角贰分。 (2)7,560.31 柒仟伍佰陆拾元零叁角壹...

中文大写金额数字应用正楷或行书填写,如壹(壹)、贰(贰)、叁、肆(肆)、伍(伍)、陆(陆)、柒、捌、玖、拾、佰、仟、万(万)、亿、元、角、分、零、整(正)等字样。转换成小写或者数字,参考下图:

试试这个 在Excel =IF(TRUNC(A2)=A2,TEXT(A2,"[dbnum2]")&"元整",IF(TRUNC(A2*10)=A2*10,TEXT(TRUNC(A2),"[dbnum2]")&"元"&TEXT(RIGHT(A2),"[dbnum2]")&"角整",TEXT(TRUNC(A2),"[dbnum2]")&"元"&IF(ISNUMBER(FIND(".0",A2)),"零",TEXT(LEFT(RIGH...

方法: 1、打开EXCEL表格,A1输入小写金额,在C1列输入:=SUBSTITUTE(SUBSTITUTE(IF(A1>-0.5%,,"负")&TEXT(INT(FIXED(ABS(A1))),"[dbnum2]G/通用格式元;;")&TEXT(RIGHT(FIXED(A1),2),"[dbnum2]0角0分;;"&IF(ABS(A1)>1%,"整",)),"零角",IF(ABS(A1)

假设1283.42在A1单元格,则公式为 =TEXT(INT(A1),"[DBNUM2]")&"元"&TEXT(MID(A1,LEN(INT(A1))+2,1),"[DBNUM2]D角")&TEXT(MID(A1,LEN(INT(A1))+3,1),"[DBNUM2]D分")&"整"

建立一个函数,函数如下 CREATE FUNCTION [dbo].[f_num_chn] (@num numeric(14,5)) RETURNS varchar(100) WITH ENCRYPTION AS BEGIN DECLARE @n_data VARCHAR(20),@c_data VARCHAR(100),@n_str VARCHAR(10),@i int SET @n_data=RIGHT(SPACE(14)+...

假如你数字在a1,只能在除a之外的其他单元格(如b1)转化,则b1=IF(A1,TEXT(INT(A1),"[dbnum2]")&IF(INT(A1)=A1,"元整","元")&TEXT(--RIGHT(INT(A1*10)),IF(--RIGHT(A1*100),"[=0]零;[dbnum2]#角","[dbnum2]#角整;;"))&TEXT(--RIGHT(A1*100),"[d...

网站地图

All rights reserved Powered by www.bcmx.net

copyright ©right 2010-2021。
www.bcmx.net内容来自网络,如有侵犯请联系客服。zhit325@qq.com