Oracle Lowercase to Uppercase Modified Edition

Actually, you don't need any software, you can do it with this

To convert the lowercase amount of RMB to uppercase format, use the format provided by Excel and change the "[dbnum2]g general format" in the custom format type to "[dbnum2] g common format "yuan"". However, there is a problem when converting decimals, such as 6, which can only be converted to "Lu Qian Ling Wu Shi." Zero Nine Circle".

So can Excel solve this congenital deficiency? There are two ways to do this (both of which are converted to b1, assuming that b1 is rounded to two decimal places by rounding the function round( ), and its value is 6,.

1. Convert in three consecutive peer cells.

1.B2 Enter the formula "=if(b1 0,"Negative amounts are invalid",int(b1))" The calculation result is 6, and then click "Format cell number Special Chinese capital number OK", b2 displays "Lu Qian Zero Wu pick", and then click "Format cell number custom", modify "[dbnum2]g general format" in the "Type" box to: [dbnum2] ("RMB") g common format "yuan", at this time b2 displays:

RMB) Lu Qian Ling Wu Shi Yuan".

2.C2 Enter "=if(b1 0,"", int(b1 10)-int(b1) 10)", also c2 is changed to: [dbnum2]g generic format "angle", c2 displays: "zero angle".

3.D2 Enter "=if(b1 0,"", int(b1 100)-int(b1 10) 10)", the same d2 is changed to: [dbnum2]g the common format "points", d2 displays: "nine points".

This enables the conversion of the uppercase amount format in three consecutive cooperating cells, as shown in Figure 1. In order for the conversion to conform to the financial format, B2 should be right-aligned, C2 columns should be unspaced and without left and right border lines, and D2 should be left-aligned.

Try this in excel

if(trunc(a2)=a2,text(a2,"[dbnum2]")&"Yuan whole",if(trunc(a2*10)=a2*10,text(trunc(a2),"[dbnum2]")&"Yuan angle integing",text(trunc(a2),"[dbnum2]")&"Yuan zero",text(left(right(a2,2)),"[dbnum2]")&"Angular minutes"))

="The Chinese yuan is full",if(trunc(a2*10)=a2*10,text(trunc(a2),"[dbnum2]")&"Yuan angle duke",text(trunc(a2),"[dbnum2]")&"Yuan zero",text(left(right(a2,2)),"[dbnum2]")&"Angular minutes"))

The function of converting RMB from lowercase to uppercase in excel is written like this:

Step 1 Enter the relevant data in the excel sheet, and enter some representative RMB lowercase data in column A to test the function of the function, step 2 Enter the formula in cell B2"=if(abs(a2)<,"",if(a2<0,"Negative",)&

if(int(abs(a2)),text(int(abs(a2)),"[dbnum2]")&"

Metaint(abs(a2))*10,"[dbnum2]")&"Corners",if(int(abs(a2))=abs(a2),,if(abs(a2)&

lt;,,"Zero")))if(round(abs(a2)*100-

int(abs(a2)*10)*10,),text(round(abs(a2)*100-int(abs(a2)*10)*10,),"

dbnum2]")&"points","whole"))"。

Step 3 After double-checking that the formula is entered correctly, press the Enter key to convert the lowercase amount in RMB in cell A2 to the uppercase amount in RMB.

Step 4 Drag the fill handle in cell B2 to copy the formula to the following related cells, then you can convert the numbers in column A to RMB capitalization.

Extract the words in the grid first.

Then convert to uppercase: ==if(h12=0,"",if(int(h12),text(trunc(h12),"[dbnum2]")&"Meta","")&if(mod(h12,1)=0,"whole",if(trunc(h12,1),if(h12=trunc(h12,1),text(left(right(h12*100,2)),"[dbnum2] 0 corner integer angle")&"0 points")),text(h12*100,"[dbnum2] 0 points")))

Suppose the tens of millions are g6

substitute(text(value(concatenate(g6,h6,i6,j6,k6,l6,m6,n6)),"[dbnum2] g generic format")&"Yuan <>0),"Zero"&text(p6,"[dbnum2] g generic format")&"points",if(and(o6<>0,p6=0),text(o6,"[dbnum2] g generic format")&"Corners",text(o6,"[dbnum2] g generic format")&"Corners"&text(p6,"[dbnum2] g generic format")&"points")))"whole"," ","")

Cells are formatted to special, Chinese capital numbers.

The landlord is so smart, he must understand this formula:

if(iserror(find(".",a1)),numberstring(int(a1),2)&"Yuan whole",if(iserror(numberstring(mid(a1,find(".",a1)+2,1),2)),numberstring(int(a1),2)&"Yuan angle integing",numberstring(int(a1),2)&"Yuan angular minutes"))

Set the cell format as, special grid test, there is a call Chinese capitalization!

Right-click on the cell and select "Format Cell", select "Special" in the "Number" page of the dialog box, select "Special" in the left column border, and select "Chinese Capital Number" on the right. That's it.

Word capitalization is an integer.

Select the Arabic numerals first, insert the numbers if it is for the 2003 version, and insert the numbers for the 2007 version.

Then select the capital one, two, three....

After you have selected all the numbers that need to be capitalized, select "Numbers" in the "Insert" menu and then select the capitalization "One Two Three Wanton" in the menu.

You can format the cells as [Chinese capital numbers], or you can convert them with formulas.

In excel, there is a function formula with uppercase in it, or you need to change the uppercase of the single box right-click and select ** format, and select uppercase in it.

No function is required, just format the cell to: Special - Chinese capital numbers.

All the answers upstairs are not as good as the landlord's first formula, and the answers are not what they asked.

If you use a formula to solve the problem of 10,000 is 0 and shows zero, the formula will be three times longer than the original, which is too scary. Therefore, it is recommended to use the auxiliary case, the method is:

Put the original formula in the auxiliary box, let's say c9, c9 will show 400 yuan for 10,000 yuan.

Then in the cell where you want to display uppercase, enter the following formula:

if(and(iserror(find("Pick up 10,000",c9))=false,iserror(find("Pick up thousands of zeros",c9)=true)),substitute(c9,"Pick up 10,000","Pick up thousands of zeros"),c9)

It will show that the renminbi is worth 400 yuan.

Note:1After setting the formula, you need to set C9 to white to avoid being printed2The above method does not take into account the addition of millions plus zeros, i.e. 1,002,000 to the formula if needed.

Support VIP Shine

Please follow his steps and try it.

With the first five strokes of Sohu shirt or Chen Qiao's five strokes, you can directly type and count the uppercase amount for Lu Baijiu to pick up ten thousand zero three thousand seven Bai Wu pick up three corners of the land for the collapse of the liquid attack two pick ten thousand zero two thousand three pick three yuan corner of the corner.

Are your current lowercase numbers a text state? What kind of data are they like, can you give some examples? What is the format of "translation" when converting to uppercase?

Generally speaking, Arabic numerals are formatted to display Chinese case ......

If it is already a textual character, then you need to "translate" it according to the rules, and there is no such format automatic conversion, and you need to write your own formula ......