answersLogoWhite

0


Want this question answered?

Be notified when an answer is posted

Add your answer:

Earn +20 pts
Q: Why is excel replacing numbers for the pound symbol?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

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


The symbol for pound is what?

The Pound Sign Is This £


What is the symbol for pound money?

The Pound Sign Is This £


What does the pound in the symbol pound stand for?

My Nan


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 does the pound symbol look like?

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


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.


What is the financial symbol of a pound?

£ or ₤


What is the symbol for a UK pound?

The pound symbol is £. Some currency conversions will sometimes refer to the currency as GBP (Great British Pound) or BPS (British Pound Sterling) or just Sterling. The pound symbol £ is based on the letter L from the Latin Libra and it is called a pound because originally the coins would have weighed one pound.