answersLogoWhite

0

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.

User Avatar

AnswerBot

1mo ago

What else can I help you with?

Related Questions

The symbol for pound is what?

The Pound Sign Is This £


What is the American pound sign?

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.


British Pound symbol?

£ is the symbol for the british pound(:


What is the symbol of pound currency?

The symbol for pound currency is: £


What is a proper way to use the pound symbol?

It should appear before any numbers. e.g. £5.00


Am unable to do SUM function in Excel when numbers are with pound symbol example pound124 pound247 but am able to do the perform SUM function with normal number?

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.


What is the symbol for pound money?

The Pound Sign Is This £


What does the pound in the symbol pound stand for?

My Nan


What does the pound symbol look like?

I have tried to type in the pound symbol for you but Answers.com won't allow it.


What is the symbol for pound in french?

- 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.


How do you change dollar sign to pound sign in Excel?

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.


How do you write one million pounds in numbers?

1000000 pounds, if it is currency, then put the 'pound symbol' in front. It looks kind of like an L.