Converting excel numbers into pound sterling

1.

The number in excel is changed into currency "#" format mostly e to the use of other formats, which can be changed back to numerical value or conventional. The specific steps are as follows:

required materials: Excel

First, open the excel file and select the number cell in currency format

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

3. Set cell format to text. Whatever you enter is what you want.

4.

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:

5.

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:

6. Look here, Microsoft's help
http://support.microsoft.com/kb/213360

however, the results are rarely different from your requirements

= spellnumber (200)
display
two hundred dollars and no centers

7.

Take excel 2016 as an example, there are the following steps:

1. Open an excel worksheet, as shown in the figure below:

8. Even if it is automatic, the exchange rate is changing every day, will your excel change automatically
the most common way is to input the exchange rate and make a fixed form.
If A1 is the value of 100 you input, then your exchange rate is 0.638 marked by A2, and the value you need is marked by 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.

9.

To convert us dollar, British pound and euro into RMB, we only need to multiply the exchange rate to solve the problem

The specific operation process is as follows:

10. As the Tianfu swordsman said, do you want to replace the symbol or convert it according to the exchange rate:

if you want to replace the symbol:
1) Ctrl + F search input: $replace input: (pound symbol, I don't know, Khan number); Then search, replace all

for exchange rate conversion:
1) enter the exchange rate of 1 US dollar to pound sterling in an empty cell, and the cell
2) select the area you want to replace: from the first cell, press the left key to the last cell, release the left key and right-click - paste special, where you can select multiply
OK!