The number format is set to Chinese currency
The reason for this phenomenon is that there is a problem in the setting. The specific solutions are as follows:
1. First, create a new excel document
you can set it in Excel and it to word. The effect is the same
the operations in Excel are as follows:
select data & gt& gt;& gt; Right click & gt& gt;& gt; Set cell & gt& gt;& gt; Check the number column & gt& gt;& gt; Click "currency" and choose the one that meets the requirements
I hope it can help you
2, toolbar: number --- value --- OK
if you can't, then format --- row --- row height --- enter a large number to see
a1a21333;" 20803;"26684< br />b1=IF(INT(A1)*100=A1*100,TEXT(INT(A1),"[ DBNum2]"& quot; " IF(INT(A1*10)=A1*10,TEXT(INT(A1),"[ DBNum2]"& quot; " TEXT(A1*10-INT(A1)*10,"[ DBNum2]"& quot; " TEXT(INT(A1),"[ DBNum2]"& quot; " IF(INT(A1*10)=INT(A1)*10," Qu" TEXT(RIGHT(INT(A1*10),"[ DBNum2]"& quot; "" TEXT(RIGHT(A1*100),"[ DBNum2]"& quot; "))
I can convert "1245.6" into & quot; One thousand two hundred and forty five yuan and sixty cents;
The latest development of the incident is that the man is also taking care of the child, but the man's wife, Xiao Lin, has not come back since she ran away from home. The man can only protect his rights through legal channels and ask Xiao Lin for compensation
when the child was born, Xiao Liu was only 18 years old, while Xiao Lin was only 17 years old. They got married and had children at the age that did not comply with the law. Although they did not get a marriage certificate, they both lived together in recent years. Now, because the child is not Xiao Liu's, so for Xiao Liu, the existence of the child has a great impact on him, and even affects Xiao Liu's marriage
so Xiao Liu wants to send the child to Xiao Lin's parents, but Xiao Lin's parents say that they can't afford it because they are old. However, when Xiao Lin's parents want to send the child away, they have already found it, but Xiao Liu's family doesn't agree