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.
fixed
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.
An error message begins with the 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
A pound the sign is like this £1
true
Multiply by -1
Equal sign
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.
There are many signs used in Excel. Three of them are the plus sign (+), the minus sign (-) and the multiplication sign (*).
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.
change the field size