Excel may replace numbers with the pound symbol (£) when the cell formatting is set to currency, particularly if the currency format is set to British pounds. Additionally, if the system's regional settings are configured for the UK, Excel may automatically display currency values using the pound symbol. This behavior can also occur if there’s an error in data entry or formatting. To resolve this, check the cell format and regional settings in Excel.
The Pound Sign Is This £
The American pound sign refers to the symbol "#", which is typically used to represent numbers in the United States. It is commonly known as the "number sign" or "hash symbol" in American English.
£ is the symbol for the british pound(:
The symbol for pound currency is: £
It should appear before any numbers. e.g. £5.00
A possible explanation is that you are typing the pound sign in yourself. If the cell content is left aligned, then it is being treated like text and so it cannot be summed. That is what happens if you type the pound sign in yourself. It thinks it is text, not a number. You should only ever type in actual numbers and then use the formatting options to add in the pound sign or whatever other symbols you may want. So type the numbers in with no signs. They should align to the right of the cell. Then use formatting to apply the pound signs. The pound signs will appear but your values will still be treated as numbers and will still be right aligned. Now you should be able to sum them.
The Pound Sign Is This £
My Nan
I have tried to type in the pound symbol for you but Answers.com won't allow it.
- the symbol for the pound (British Currency) translated in French "la livre" is £ as in England,- the "hash" key symbol (#) and the related weight unit are not used in France.
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.
1000000 pounds, if it is currency, then put the 'pound symbol' in front. It looks kind of like an L.