Excel currency number splitting

1.

bus line: No.3 → No.15, the whole journey is about 10.3km

1. Walk about 90m from Tonghua highway passenger station (old station) to passenger station

2. Take No.3 bus, pass 3 stations, and then reach Petrochemical station (or take No.39 bus)

3. Walk about 150m to Yamaha motorcycle monopoly station

4. Take No.15 bus, pass 11 stations, and reach gas station (G201)

5 Walk about 320 meters to the driver examination center of traffic police detachment of Tonghua Public Security Bureau

2. Go out to install, repair and debug equipment for customers.

3. Select data -- data -- column -- fixed width -- next step -- set field width (separate currency symbol from number -- three digits in general?) Just click on the scale) - next step - done.

4. Format & gt; Cell format & gt; Value & gt; Custom number format

5. Suppose the amount is in A68, the rightmost space is N68, and the rightmost space is input = if ($A68, left (& right&# 165;& quot;&$ a68*100,COLUMNS(N:$N))),"& quot;) Right pull

6. If it's 07, point data, column, split symbol, column, other symbols, input - complete
and then if you want to keep "-", insert another column and fill in "-"

7. Split landlord can be realized by three functions: left, right and mid
left: take the text from the first character on the left, and the parameter indicates the number of texts to be taken
right: take the text from the first character on the right, and the parameter indicates the number of texts to be taken
mid: the first parameter indicates the number of texts to be taken from the specified text character, and the second parameter indicates the number of texts to be taken

give the landlord three examples to master flexibly,
suppose that the data in A1 cell is "asdfg"
= left (a1,3), ASD
= right (a1,4), SDFG
= mid (a1,2,2), SD

as for the data transposed to and not covered, only hyphen "&" can be used
the data set in A1 cell is "asdfg", "123" in cell B1
first write the formula in cell C1: C1 = A1 & B1 to get asdfg123
and then cut C1 to cell B1

8. You don't need to enter a formula. Split the first line first, and then directly use Ctrl + e to complete it.
for example, fill in B1, C1, D1 first, then select B2, and press the same operation as Ctrl + e, C, and D columns

9. When you enter a number into a cell, the number may not appear in the worksheet as it was entered. For example, if you enter 9 / 10, excel will display September 10. This is because excel saves all numbers and dates in the form of numbers. By default, 9 / 10 scores are recognized as dates. When they are displayed on the screen, they will be displayed in the default "number format" of dates. To change it, we must use the setting of cell number format

excel provides a large number of data formats, which are divided into: general, numerical, currency, accounting specific, date, time, percentage, score, scientific counting, text, special and user-defined. If no settings are made, the default "general" cell format will be used for input

the method to open excel number format setting is as follows:

select the cell or range to set the number format, right-click, and select "set cell format..." in the right-click menu to open the "set cell format" dialog box with the "number" tab, as shown in Figure 1<

Figure 1 number options in the set cell Format dialog box

1. Set to the agreed number format

first select the cell or range to be set, open the set cell Format dialog box, and enter the number tab, as shown in Figure 1. Select the number format you want<

try:

1) create a new worksheet, input the text as shown in Figure 2 in A1: a11, and set it to right alignment

2) set the "number" format of B1: B11 as follows: numerical value (decimal place is 2), currency (decimal place is 2, currency symbol is "￥"), special for accounting (decimal place is 2, currency symbol is "￥", pay attention to the difference between "special for accounting" format and "currency" format), date (selection type: * March 14, 2001) Time (the selection type is 13:30:55), percentage (the decimal place is 2), fraction, scientific counting, text, special (the type is set to "Chinese capital number"), custom (enter "000000" in the type)

3) then fill in "1234.56" in B1: B11 cells, and the results displayed in each cell will be as shown in Figure 2

Figure 2 various number formats

* tips:

1) if you only make some relatively simple settings for some data formats, you can directly use the "number" format button group in the "start" function area to realize it, as shown in Figure 3. For the specific meaning of each button, the cursor can be positioned above the button for a short period of time, and excel will automatically pop up the function description of the button.

10. =Floor (a1,10) / 10 (rounding one place)
= floor (A1100) / 10 + mod (a1,10) (rounding ten places)
= floor (A11000) / 10 + mod (A1100) (rounding one hundred places)
= mod (A11000) (rounding one thousand places)
just add 0 for more than five places