answersLogoWhite

0


Best Answer

When you format the cell or range for currency, you can select the currency symbol you want to display. The default is $ if your computer setting is for US. In the currency formatting drop-down for symbol, just select the sign you want to display.

User Avatar

Wiki User

14y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: How do you change dollar sign to pound sign in Excel?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

Is a dollar sign that is displayed to the far left of a cell in excel a floating or fixed dollar sign?

fixed


How do you specify that the cell address currently in the edit line will change if copied to another cell?

In Microsoft Excel, if the dollar sign is used in the formula, cell references don't change when a formula is copied to another cell. Use or don't use the dollar sign according to your purpose.


What does excel displays error message that begins with?

An error message begins with the pound sign (#).


How do you change US dollar sign to UK pound sign?

Your Region AND language settings are incorrect on your computer. This is an extremely common fault, often with new machines the first time a Word processor is used. In Windows - START / CONTROL PANEL / REGIONAL AND LANGUAGE OPTIONS here you should be able to correct the error


How do you say dollar in Great Britain?

A pound the sign is like this £1


Is it true that the currency style format cannot be used with the floating dollar sign in excel?

true


In Microsoft Excel cell How do you change the negative sign to positive?

Multiply by -1


What is The preceding a formula is an important part of the formula because it alerts Excel that a formula or function is being entered and not text.?

Equal sign


How do you remove the dollar sign from a excel cell to show just numbers?

Change the format of the cell from currency to another format. Right-click and select the cell formatting option. Select whatever number format you want to use.


What are three signs in Excel?

There are many signs used in Excel. Three of them are the plus sign (+), the minus sign (-) and the multiplication sign (*).


Absolute references are marked with what?

Absolute references in Excel are marked with a dollar sign ($) before the column letter and/or row number. For example, $A$1 would be an absolute reference to cell A1, meaning that the reference will not change when copied to other cells.


How can show the euro instead of the dollar sign on access?

change the field size