Excel digital currency multiplication

1. Right click "user defined cell format" = =, special = =, Chinese capitalization
if you are not satisfied, try this:
= numberstring (1234567890,1)
parameter 1 can be modified, 123456.. is a hypothetical number, which can be changed to cell name
if not, try this:
= subordinate (text (fixed (A1)), & quote[& gt; 0][dbnum2];[& lt; 0] negative [dbnum2]& quot;)& TEXT(RIGHT(FIXED(A1),2)," Yuan [dbnum2] 0 Jiao 0 fen& quot;& IF(ABS(A1)> 1%," Yuan integer & quot;,)& quot; Zero angle;, IF(ABS(A1)< 1,," Zero & quot;)& quot; Zero & quot& quot; Integer (& quot;)
where A1 is the cell of hypothetical data.

2. =TEXT(RMB(A1), "[] g& quot;& TEXT(INT(ABS(A1)+0.5%), "[ dbnum2]G/36890;-29992;-26684;-24335;-20803;&& quot;& SUBSTITUTE(SUBSTITUTE(TEXT(RIGHT(RMB(A1),2),"[ dbnum2]035282;020998;; .25972;quot;," quot; (38646;)35282", IF(A1^2< 1," 38646,"] quot; .38646;. quot; 25972;quot;]

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. Select the table you want to set, right-click and select set cell format - number - currency

5. Select the time column, click "data" in the menu bar, select "sort", pop up "sort warning", select "expand selected area", click "sort", select "ascending" in "main keywords", then select "Untitled row" in "my data area", and then click "OK".

6. Copy to excel, set cell format to currency, and then paste back to word.

7. Your number may be in text format and should be changed to a numeric value first.

8. If it is a digital currency format, it can be summed according to the data. If it is not, it really needs to be replaced. Replacement is simple, find ￥, replace with blank, replace all
if you pull the selected area and you display the summation result in the status bar below, it indicates that the data is not in the data format and needs to be converted< br />
[email protected]

9.

The default format can be set in Excel options. The following steps show that the software is Excel 2007

First, open an excel file on the computer, and then click the office button in the upper left corner of the page

10.

Here we can solve the problem with only one excel sheet

design a good style first, such as this:

a very simple example, the column is the date, the row is the member, and the gray is the holiday. Of course, you can design your own style. We just need everyone to fill in their own jobs. Shared folders are available here. However, for the team that forces gegao, it's too unskilled. At this time, we only need to use a shared form plug-in to share and edit multiple tables

you have a lot of team members that can be pre-defined. Then assign them rows. In this way, everyone's excel form on the computer will automatically lock the area that cannot be edited, leaving only his own line, isn't it amazing? The form is the same

fill in the content and save

there is nothing to say about writing the form. It's exactly the same. Write your own, and then save it. The content will be automatically synchronized when you save it. Everyone can see the content written by the other party, which can not only motivate employees to leave a of this form, but also directly archive it. HR people just need to do a good job in the style sheet at the beginning of the month, assign permissions, and send mass mails. Don't be too convenient