Position: Home page » Currency » The number format is set to Chinese currency

The number format is set to Chinese currency

Publish: 2021-04-30 07:51:33
1.

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

2. After opening the file form, select the cell that needs to set currency, there is a format option in the upper right corner of the form, which can be set as currency. If you don't understand, please leave a message and ask. Thank you!
3. This is easier! Suppose it's 23.68 yuan, select this cell - right click - set cell format - Special - Chinese capital number (on the right)
4. Hello, word does not have this conversion function. However,
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
5. 1. Select the column to be operated, right-click set cell format
2, toolbar: number --- value --- OK
6. IF(A2< 0," "" quot; quot; TEXT(TRUNC(ABS(ROUND(A2,2),"[ DBNum2]"& quot; " IF(ISERR(FIND("& quot; ROUND(A2,2),"& quot; TEXT(RIGHT(TRUNC(ROUND(A2,2)*10),"[ DBNum2]")& IF(ISERR(FIND) 0" TEXT(A2," 0.00"),& quot; "" quot; quot; IF(LEFT(RIGHT(ROUND(A2,2),3)="& quot; TEXT(RIGHT(ROUND(A2,2),"[ DBNum2]"& quot; "" quot; ") A236135;"24065;" 26684s;
7. Format - & gt; Column - & gt; Column width --- enter a large number to see
if you can't, then format --- row --- row height --- enter a large number to see
8. "24456;" 38271;"31616;" 21333;"19981;" 26469;"br

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; "))
9. Contact me on QQ, I will send you a page
I can convert "1245.6" into & quot; One thousand two hundred and forty five yuan and sixty cents;
10.

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

Hot content
Inn digger Publish: 2021-05-29 20:04:36 Views: 341
Purchase of virtual currency in trust contract dispute Publish: 2021-05-29 20:04:33 Views: 942
Blockchain trust machine Publish: 2021-05-29 20:04:26 Views: 720
Brief introduction of ant mine Publish: 2021-05-29 20:04:25 Views: 848
Will digital currency open in November Publish: 2021-05-29 19:56:16 Views: 861
Global digital currency asset exchange Publish: 2021-05-29 19:54:29 Views: 603
Mining chip machine S11 Publish: 2021-05-29 19:54:26 Views: 945
Ethereum algorithm Sha3 Publish: 2021-05-29 19:52:40 Views: 643
Talking about blockchain is not reliable Publish: 2021-05-29 19:52:26 Views: 754
Mining machine node query Publish: 2021-05-29 19:36:37 Views: 750