Changing currency format in Microsoft Excel?

Question

Hey guys! I downloaded a template for some work I have to do and the template I am using has formatted number additions so when things get added together it will be in dollars, e.g. 1+1=$2 but I need them to be in british pounds rather then dollars, how do I do this?

Answer 1

1.Right click the cell(s)

2. select format cells

3. go to the numbers tab

4. select currency

5. select the symbol drop down

6. select English (United kingdom)



This however will not adjust for exchange rates between usd and your funny money :)



so as long as you are working with a single currency you are ok.



Otherwise you will have to edit the formulate that generates the total and multiply it by the exchange rate.

Answer 2

Yes dead easy.



Pull up the sheet. If you want the whole sheet done then with cell A1 highlighted

press Ctrl+A so the whole sheet is highlighted so every cell will be in £ Sterling.



If it's just one Column then just do that one column.



Then Format ► Cells ► Number ► In the Category highlight Currency ►

In Symbol on the right hand side select £ in the drop down ► OK



You can also select how many decimal points you want to works to as well.



The whole sheet or the single column will now show and work in £ Sterling.

Answer 3

Your numbers are entered as a text textile, (to illustrate there's an area in the previous quantity, and so on) Or, the kind is formatted as a text textile you may evaluate your quantity in A1 =ISNUMBER(A1) If the effect is fake your quantity in A1 isn't a quantity yet text textile (string).