answersLogoWhite

0


Best Answer

Number formats are codes that help determine how numbers look in Excel. Double-click on the text, then click the number tab in the dialog box to see the formatting. You can choose many different types of number formatting, depending on the purpose for displaying the numbers. Some common number formats are currency, time, and percents.

See related links to read more information about number formatting.

User Avatar

Wiki User

12y ago
This answer is:
User Avatar
More answers
User Avatar

Wiki User

11y ago

A number format decides how a number you type it is actually displayed. So that would include things like percentage, currency, scientific, fraction etc. You can also choose the amount of decimal places to show.

This answer is:
User Avatar

User Avatar

Wiki User

6y ago

Format > Cells > Currency

This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: How should numbers be formatted in Microsoft Excel?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

What data types can be input into Microsoft Excel 2000 Spreadsheets?

text and numbers formatted in a variety of ways


What is A Microsoft Excel workbook with a pre-formatted layout and style?

A template.


Besides text what can be formatted as a hyperlink in Excel?

numbers, images, and objects


How high do the numbers on Microsoft Excel go?

65,536! 1,048,576 with Excel 2007


IN Microsoft Excel when numbers are used as columns or row labels how should they be formatted?

That is purely the choice of the user. In different situations they may choose to format them in different ways. They may do something like bold them or change their colour or put a border around the cell.


What should be formatted in excel so that the records are easily distinguished?

Table


Why is your Excel numbers sum a date?

The cell has been formatted to be in date format. You just need to format the cell to show numbers. If a number is formatted as a date, it will show an actual date.


Can a person complete calculations in Microsoft Excel 2003?

Yes they can. It is what Microsoft Excel is for.Yes they can. It is what Microsoft Excel is for.Yes they can. It is what Microsoft Excel is for.Yes they can. It is what Microsoft Excel is for.Yes they can. It is what Microsoft Excel is for.Yes they can. It is what Microsoft Excel is for.Yes they can. It is what Microsoft Excel is for.Yes they can. It is what Microsoft Excel is for.Yes they can. It is what Microsoft Excel is for.Yes they can. It is what Microsoft Excel is for.Yes they can. It is what Microsoft Excel is for.


What are examples of types of data in Microsoft Excel?

numbers and text


What should you do if you have accidentally deleted Microsoft Excel?

You should be able to do a system restore, if that doesnt work simply reinstall the excel from your Microsoft Office.


Do creative writers use Microsoft Word?

Creative writers use a variety of programs, including Word,Office,and Excel, which are well-formatted programs, instead of Microsoft wordpad or notepad.


What is a text in an Excel spreadsheet?

Text are characters not formatted as numbers. Usually they are letters, but sometimes numbers are formatted to be treated as text (unable to manipulate as numbers). An example would be to format zip codes as text, so you can display the leading zero.