How to convert money into numbers in spreadsheets

1. Suppose the text is in A1,
enter the formula:
= -- A1
then the cell where the formula is located, paste the value to the place you want, and set the pasted cell to currency format.

2. 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.

3.

The operation method of changing RMB into US dollar in excel is as follows:

1. Select the cell range to be changed in

Second, right-click the cell range and click "set cell format" in the drop-down menu (or use the shortcut key Ctrl + 1); The format cell dialog box opens

Third, select the number button in the set cell Format dialog box; At this time, the drop-down box of "number" appears

(4) select "currency" in the drop-down box where "number" appears

In the currency dialog box, change the RMB symbol to the US dollar symbol and click save. As shown in the figure below:

5. Tengjia enamel steel water tank is to use HSC series enamel as base glaze and surface glaze δ 2- δ 5. A new type of water tank is assembled by firing plates on enamel.
Tengjia stainless steel water tank is commonly used as stainless steel fire water tank, and the square combined water tank is made of SUS304 and stainless steel plate, which is formed by stamping.

6. If the original ￥ is entered manually, excel will recognize it as text, so it cannot be directly converted to currency format
you can delete ￥ in batches by using the search and replace function, and then set it to currency format.

7.

Use the text function

text function to convert a numeric value to text in a specified number format

syntax: = text (numerical value, format)

example: data in column d

8.

There are many methods to batch convert text numbers into numbers in Excel. Here are two simple methods

operating system: win10; Software version: office2007

method 1: direct conversion method

1. Select the text number, and the small icon

as shown in the figure will appear in the upper right corner

9. Hello, I'll help you to explain: 1. If you haven't signed up for the self-study examination in Anhui, it doesn't involve the issue of self-study status. You can apply for the self-study examination of this major in Shanghai directly. 2. Transfer from self-taught examination to student status means that you have passed one or several courses in the self-taught examination of the same major in Anhui Province, and you need to continue to complete the examination of this major in Shanghai. You can transfer the results of Anhui province directly to Shanghai, and then continue to complete the rest of the courses to apply for graation in Shanghai. 3. You are not involved in the issue of transfer from self-taught examination to student status. The student status of self-taught examination and that of students on campus are not a system. But need to remind is: after you apply for the self-taught examination in Shanghai, you after more than 10 courses all need to take the examination in Shanghai ~ if you want to take the examination in Anhui, it is recommended that you directly find an Anhui of the same professional to study and test it ~ come on!!