Currency format to number function
To convert a number to a currency number is to set the value cell format to currency format. The following steps are as follows:
-
select the cell to be set, right-click to select the cell format
-
to open the cell Format dialog box, click the number tab (the general default number tab is activated)
-
to select the currency symbol and decimal point according to your own needs, Then determine the specific recording operation of
< / OL >
as shown in the following figure:
1. First of all, open our computer, enter into the computer desktop, find my world in the computer desktop, enter into my world game
Gambling crime, can call the police. Whoever, for the purpose of making profits, gathers people to gamble or takes gambling as a business shall be sentenced to fixed-term imprisonment of not more than three years, criminal detention or public surveillance and shall also be fined
in view of the problem of how to distinguish the gambling behavior concerned by the masses from the mass entertainment activities, the relevant person in charge of the special action office of the Ministry of public security against illegal and criminal gambling activities made an explanation:
1. To see whether to profit from it, to constitute the crime of gambling, objectively, it is limited to "gathering people to gamble", "opening casinos" or "taking gambling as a business"“ "Gathering people to gamble" refers to the behavior of organizing, summoning and luring many people to gamble, from which one can profit“ "Gambling as a business" refers to the behavior of gambling frequently and taking gambling to obtain money as its life or main economic source
"setting up a gambling house" refers to the act of providing gambling places and equipment for others to gamble in, and making profits from them; There is no profit from mass entertainment
2. The amount of lottery tickets depends on the indivial, regional economic situation and the consumption level accepted by the public
From the subjective point of view, whether it is for profit or not is the subjective element of gambling crime; Mass entertainment aims at leisure4. From the main point of view, mass entertainment is mostly between family members, relatives and friends
the relevant departments are actively studying and formulating the judicial interpretation focusing on cracking down on illegal and criminal activities of gambling. The judicial interpretation will make specific provisions on the identification of online gambling crime, the definition of the scope of gambling funds, and the distinction between illegal gambling activities and mass entertainment activities, which is expected to be issued in the near future
Use the corresponding function to convert the numerical RMB into capital in Excel. Please refer to the following steps for specific operation. The demo software version is Excel2007
First, open an excel file on the computer and enter the editing area, as shown in the figure
Public Function RMBDX(M)
RMBDX = Replace(Application.Text(Round(M + 0.00000001, 2), "[DBnum2]"), ".", "元")
RMBDX = IIf(Left(Right(RMBDX, 3), 1) = "元", Left(RMBDX, Len(RMBDX) - 1) & "角" & Right(RMBDX, 1) & "分", IIf(Left(Right(RMBDX, 2), 1) = "元", RMBDX & "角整", IIf(RMBDX = "零", "", RMBDX & "元整")))
RMBDX = Replace(Replace(Replace(Replace(RMBDX, "零元零角", ""), "零元", ""), "零角", "零"), "-", "负")
End Function
假如你要转换的数值在A1单元格，在B1或其他单元格输入＝ RMBDX(A1)
这是自定义函数，office 2003里面应该有带的
the second one is the same as the first one
the third one is ￥ 1234
if you really want the result, you can
Select & 39; ￥'|| 1234 from Al
--- supplement -
running on XP, the version is 9i, and the character set is the default
UNIX, I can help you to have a look on Monday, now there is no environment
26041;.65861;65306;
1.-122891;25171;.24320;EXCELL 34920;-26684;65292;A1-36755;-20837;<20889;<-379;<>>>3906999292x22312;";(2037;2037;2037;2626266306530303065;(SUBSTITUTE;) 0.5%," 12367""& amp; TEXT(INT(FIXED(ABS(A1)), "[ dbnum2]G/36890;-29992;-26684;-24335;-20803;&& quot;& amp; TEXT(RIGHT(FIXED(A1),2),"[ dbnum2]035282;/020998;& quot;& amp; IF(ABS(A1)> 1%, " .25972;quot;] quot; (38646;)35282", IF(ABS(A1)< 1," 38646,"] quot; .38646;. quot; 25972;quot;2.122891.30830;<23450;<21518;<25928;<26524;<22914;<22270p>