Excel digital currency conversion

1. Select all the tables, and then Ctrl + Shift + ~ should be OK. The last symbol is the wave sign. Try it

2. Even if it is automatic, the exchange rate is changing every day, will your excel automatically change
the most common way is to input the exchange rate and make a fixed form.
If A1 is the value you input 100, then your exchange rate is marked with A2 0.638, and the value you need is marked with A3. You only need to use a1xa2, and your fixed form can be made, but in this way, all kinds of currencies have to use different forms
sorry, that's all I can do! Hope to help you.

3.

To convert a number to a currency number is to set the value cell format to currency format. The following steps are as follows:

1. select the cell to be set, right-click to select the cell format

2. to open the cell Format dialog box, click the number tab (the general default number tab is activated)

3. 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:

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

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

7. 1. Baosteel Special enamel plate is the most important material of enamel liner. The quality of steel plate must be selected according to the requirements of forming (deformation, welding, etc.), enameling process and enamel procts. The expansion coefficient of enamel is 32 × 10-7
the carbon content of the selected plate is ≤ 0.08%. The yield limit and strength limit of the steel are increased, but the elongation is decreased when the steel contains appropriate amount of manganese. Therefore, the higher the manganese content, the greater the deformation force required
for carbon steel, silicon and manganese are the resies of deoxidizer ring smelting. In general, silicon content & lt; 0.37% of the steel plate can be used for deep drawing, but beyond this value, even the steel with low carbon content will become hard and brittle, which is not suitable for deep drawing and affects the sealing performance. The existence of sulfide will affect the microstructure of steel plate to a great extent, promote the generation of stripe structure, and rece the plasticity and toughness of finished steel, that is, rece the drawing performance of finished steel, and bubbles and pores will appear in the porcelain layer. Phosphorus dissolved in ferrite can significantly rece the plasticity of finished steel, but improve its strength and hardness; 0.06% Titanium added to steel is very beneficial to enamel. Because it can combine with various components in enamel and increase the density, Baosteel Special enamel plate BTC 330r is the most ideal base material for enamel liner
2. The water tank is just a popular hemispherical pressure head
the pressure tank head is made of 2mm thick special enamel steel plate. The hemispherical shape of the maximum limit should be achieved in the design, so that the bearing capacity and fatigue resistance can reach the best. To ensure the minimum deformation of enamel water tank after long-term use, so as to extend the service life of enamel water tank. When the pressure is 1.5 times of the rated pressure, the times of pressure can reach 300000
3. Structural characteristics of the tank
the tank adopts double flange structure, which solves the hidden trouble of pool coating quality caused by the failure to grind the welded joint before pool coating; The butt welding method of head and barrel body can avoid bubble ring pool coating by conventional lap welding method; The special water tank fixed belt can solve the hidden trouble of enamel liner damage caused by long time suspension of water tank; The special enamel electric heating can solve the problems of low heating efficiency, waste of resources and hidden danger of safety after the common electric heating is attached with scale; The bending welding method of the medium water nozzle solves the problem of poor medium flow in the past right angle welding.

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

9. Select the cell to be transferred_ Right click_ Format Cells_ Numbers_ Select the currency below (you can choose the currency symbol with or without)

10.

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