ISSUE WITH CONVERTING CAPITALIZATION IN EXCEL

A small fish that wants to fly.

Scholar. May 18 14:11 In fact, excel is not easy to use in this aspect, it is recommended **WPS2005 personal version (including Kingsoft text, Kingsoft **, Kingsoft presentation three commonly used office software, barrier-free access to all versions of office files), just register a pass to use and upgrade for free, there is a special format "RMB capitalization", which is very suitable for Chinese.

If you use Excel, it is very troublesome to convert it through functions. I have here humihong2 provided the formula as "=if(h16<,"",if(h16<0,"Negative element angle",if(int(h16)=h16,,if(h16<,,"Zero")))if(round((h16)*100-int(h16*10)*10,),text(round(h16*100-int(h16*10)*10,),"[dbnum2]")&"points","whole"It turned out that there was a full stop after the division and the whole, which was actually useless, so I changed it), and the effect was also good. The h16 in the formula is the cell to be converted (which can be modified), copy it to another location and paste it to use.

If the cell you use is not h16, it is more troublesome to change it individually, and select the cell, use the find and replace function, check h16, replace it with the cell you want to use, such as e8, and replace it all.

Two files are provided in the attachment, which are Excel (using the above formula) and WPS** in ET format, which you can refer to. Because I don't know if you have decompression software, I used a self-extracting format.

Attachment: RMB capitalization. exe

This was modified on May 19 at 11:54 AM.

Custom formatting, formulas are cumbersome and can be simple.

First of all, we open the excel file that needs to be processed, in order to facilitate **, we first maximize the excel window;

Method 1. Use the [numberstring] formula, for example: convert 4500 of cell F2 to uppercase, then enter the formula in g2.

numberstring(f2,2)], and then click the blank cell or press the [Enter] key on the keyboard to get: wanton Wu Bai;

Method two. Enter the numeric value in **, select the number cell you want to convert to uppercase, right-click and select [Set Cell Format], select [Number] in the first row of the pop-up settings dialog box, find [Special] in the category, select [Chinese Uppercase Number], click [OK] to convert to uppercase.

First, enter [=numberstring(f2,2)] in the cell (f2 represents the cell that needs to be converted to uppercase values), and you can confirm;

Secondly, select the cells to be converted, right-click, and select [Format Cells] - [Number] - [Special] - [Chinese Capital Number], and [OK].

1. Open Excel** and select the number.

<>3. Select "Number" and "Special" in the Format Cell dialog box.

4. Select Chinese capital numbers.

5. Finally, click OK, and you're done.

Method:

2. Then copy and paste the lowercase amount into the cell of the uppercase amount, and then right-click to select the set cell format.

3. Then in the cell format, select special, and then select the last RMB capitalization in the right type.

1. First open your data excel**.

2. The first method is to copy and paste the lowercase amount into the cell of the uppercase amount, and then right-click to select Set Format Cell.

3. Then in the cell format, select special, and then select the last RMB capitalization in the right type.

4. After completing the above operations, select RMB uppercase and confirm, and the lowercase amount will be automatically replaced with the uppercase amount.

5. The second method, in the blank cell of the uppercase amount, enter a V, and then enter the lowercase amount number.

6. Be sure to enter v first, and then enter the lowercase number amount, it will be automatically replaced with an uppercase amount, and after entering, select the second line of RMB uppercase.

Money is not everything, but no money is everything. Problems that can be solved with money are not big problems.

In this section, Xiaofu will explore the method of converting amounts into uppercase amounts.

Let's start with two ways to convert numbers to capitalization.

1. Adjust the formatting.

By formatting cells - Special - Chinese capital numbers.

Convert the 12800 of cell A2 to: 10,000 2000.

Convert the A3 cell to: 捌pick up. Split open.

2. Use the function method.

We use the numberstring(A2,2) formula.

Convert lowercase numbers to uppercase numbers as well.

When a decimal point is encountered, the decimal point is rounded to a whole number first.

Then convert it to uppercase.

So when converted, it became 89 uppercase pick-up.

We found. These two methods make it easy to convert numbers to uppercase.

But none of them can realize the embodiment of circles, corners, and points.

Here are two ways to improve.

1. text

text(int(a2),[dbnum2]) metatext(mid(a2,len(int(a2))+2,1), [dbnum2]d angle.

text(mid(a2,len(int(a2))+3,1),[dbnum2]ddecent).

2. NumberString

numberstring(a2,2)elementnumberstring(int(a2*10)-int(a2)*10,2)anglenumberstring(round(int(a2*100)-int(a2*10)*10,0),2)

You don't need to remember these two methods, you can directly copy and paste them when you need to use them, and replace the cell references, and it is recommended to use the first text method.