Electronic application form
[Users questions | Browse:37 | Favorites]
Users questions: Can make 500 yuan on the A1 in the A2 automatically capitalized as follows: five hundred .
Experts answer: EXCLE case conversion to achieve monetary amount EXCEL Although set in the cell number can be converted to lowercase the Chinese capital, but the face angle of time-sharing, there will be a little problem . Such as U.S. dollars 123. 45, according to the Chinese capital should be in dollars per wantonly angle rented furnishings Er Shi Wu triple points, EXCEL converted is "rented furnishings Ershi triplet. Wantonly Wu." Thinking a moment, it appears only through the separation of integral part, fractional angle, decimal points to achieve. At the same time according to custom, if there is no sub-spaces, the habit of adding a " The whole "word into the issue have to consider. Therefore the function To see if an integer, will there corner. After much debugging, finally succeeded. Realized as follows: Jiashe to Zhuanhuan De Shu Zi A1, we Fen Li Zai 3 cell to achieve, A2 shows the nearest whole number, B2 show corner, C2 was Said sub-bit. If the one is the last one, is to not display. Reference then the A2 column function: = IF (INT (A1)-A1 = 0, TEXT (INT (A1), "[DBNum2] [$ -804] G * common format") & "per the whole", TEXT ( I NT (A1), "[DBNum2] [$ -804] G * Universal format") & "dollars") references the function column B2: = IF (INT (A1)-A1 = 0, "", IF (A1 * 10-INT (A1 * 10) = 0, TEXT (INT (A1 * 10-INT (A1) * 10), "[DBNum2] [$ -804] G * common format") & "corner the whole", TEXT (INT (A1 * 10-INT (A1) * 10), "[DBNum2 ] [$ -804] G * common format ") &" Point " )) References the function column C2: = IF (INT (A1 * 10)-A1 * 10 = 0, "", TEXT (INT (A1 * 100-INT (A1 * 10) * 10), "[DBNum2] [$ -804] G * common format ") &" minutes "), through Adjust the cell size, and will set the right hand side A2, B2 set to center, C2 set to the left and can be achieved. But the piece together in the display after all, beautiful, and B2 cells sometimes two words, sometimes words, when I think of the text value of the merged cells, tested, and the ultimate Is displayed in a cell. As follows: In the second line, complete the formula, the hidden, as the transition of the cell, the A3 column enter "= A2 & B2 & C2", upper case is displayed in a cell, and that simple! The above information has come from the Fengqing blog. Want to help you, I wish Hello Win!
Experts answer: EXCLE case conversion to achieve monetary amount EXCEL Although set in the cell number can be converted to lowercase the Chinese capital, but the face angle of time-sharing, there will be a little problem . Such as U.S. dollars 123. 45, according to the Chinese capital should be in dollars per wantonly angle rented furnishings Er Shi Wu triple points, EXCEL converted is "rented furnishings Ershi triplet. Wantonly Wu." Thinking a moment, it appears only through the separation of integral part, fractional angle, decimal points to achieve. At the same time according to custom, if there is no sub-spaces, the habit of adding a " The whole "word into the issue have to consider. Therefore the function To see if an integer, will there corner. After much debugging, finally succeeded. Realized as follows: Jiashe to Zhuanhuan De Shu Zi A1, we Fen Li Zai 3 cell to achieve, A2 shows the nearest whole number, B2 show corner, C2 was Said sub-bit. If the one is the last one, is to not display. Reference then the A2 column function: = IF (INT (A1)-A1 = 0, TEXT (INT (A1), "[DBNum2] [$ -804] G * common format") & "per the whole", TEXT ( I NT (A1), "[DBNum2] [$ -804] G * Universal format") & "dollars") references the function column B2: = IF (INT (A1)-A1 = 0, "", IF (A1 * 10-INT (A1 * 10) = 0, TEXT (INT (A1 * 10-INT (A1) * 10), "[DBNum2] [$ -804] G * common format") & "corner the whole", TEXT (INT (A1 * 10-INT (A1) * 10), "[DBNum2 ] [$ -804] G * common format ") &" Point " )) References the function column C2: = IF (INT (A1 * 10)-A1 * 10 = 0, "", TEXT (INT (A1 * 100-INT (A1 * 10) * 10), "[DBNum2] [$ -804] G * common format ") &" minutes "), through Adjust the cell size, and will set the right hand side A2, B2 set to center, C2 set to the left and can be achieved. But the piece together in the display after all, beautiful, and B2 cells sometimes two words, sometimes words, when I think of the text value of the merged cells, tested, and the ultimate Is displayed in a cell. As follows: In the second line, complete the formula, the hidden, as the transition of the cell, the A3 column enter "= A2 & B2 & C2", upper case is displayed in a cell, and that simple! The above information has come from the Fengqing blog. Want to help you, I wish Hello Win!
- What are the features the computer network?
- Describes the basic components of computer work
- How to determine your computer does not svchost trojan, how to delete
- Script virus malicious Web site how to do?
- Does the computer have universal health drive
- Fn key on a laptop how to use what is useful
- Help: This is a computer problem, how to repair?
- How to identify computer hardware is good or bad
- How to set double click to open shortcut icon?
- Internet system for personal use to restore it?
- This information provided by the users.Thanks!
Computer Knowledge Copyright 2005-2015 All Rights Reserved.