answersLogoWhite

0

It is better to type in numbers in the ordinary manner and then apply the formatting using the spreadsheet. If you type currency symbols in directly, it will often not be treated as a number.

User Avatar

Wiki User

15y ago

What else can I help you with?

Related Questions

Why are pound signs not put into spreadsheets?

When you are entering what are going to be currency values, it is best to just type the numbers without any currency symbols. Then when they are all in, you can format them to the currency you want and it will put in the symbol that you choose. If you try to type a currency symbol in as you are entering the numbers, it may treat it as being text and not numbers, which is why it is best not to type any currency symbols.


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 number data in Microsoft Excel?

Any type of data that is numbers. Spreadsheets mainly deal with numbers, but you also have text, dates, times and other data types.Any type of data that is numbers. Spreadsheets mainly deal with numbers, but you also have text, dates, times and other data types.Any type of data that is numbers. Spreadsheets mainly deal with numbers, but you also have text, dates, times and other data types.Any type of data that is numbers. Spreadsheets mainly deal with numbers, but you also have text, dates, times and other data types.Any type of data that is numbers. Spreadsheets mainly deal with numbers, but you also have text, dates, times and other data types.Any type of data that is numbers. Spreadsheets mainly deal with numbers, but you also have text, dates, times and other data types.Any type of data that is numbers. Spreadsheets mainly deal with numbers, but you also have text, dates, times and other data types.Any type of data that is numbers. Spreadsheets mainly deal with numbers, but you also have text, dates, times and other data types.Any type of data that is numbers. Spreadsheets mainly deal with numbers, but you also have text, dates, times and other data types.Any type of data that is numbers. Spreadsheets mainly deal with numbers, but you also have text, dates, times and other data types.Any type of data that is numbers. Spreadsheets mainly deal with numbers, but you also have text, dates, times and other data types.


What is the type for the software are use for spreadsheet?

You use spreadsheet software to create spreadsheets.


What type of software works with the system to specific tasks such as word processing and spreadsheets?

application


What are some important construction safety signs to know?

Important construction signs include warning signs with regard to electrical danger. There are signs that would indicate that the worker should wear some safety equipment such as googles or a helmet. A final type of sign is the type that indicates an exit or emergency exit.


What should you do if someone says hello to you?

Throw up multiple gang signs, if you don't know any. Just go on Youtube and type in gang signs.


Where can I buy outdoor led signs?

You could try stewardsigns.com since that is what they specialize in. They should have the type of led signs that you need and are probably also able to custom order them.


What are features of spreadsheets?

type letters,research paper


What represents the type of analysis that spreadsheets are particularly good at per forming?

Without listing the options, this question cannot be answered.


What type of money does Wales have?

The Pound


If im 69 kilo what is that in pound?

69 kilo = 152.11 pound. To convert kilo to pound or vice versa, just type in 'x kilo to pound' in google. 69 kilo = 152.11 pound. To convert kilo to pound or vice versa, just type in 'x kilo to pound' in google.