answersLogoWhite

0

That depends on what you are using the numbers for. There are different number formats available. On some occasions you may need numbers formatted as percentages, other times as currency and so on. You choose what is appropriate. First select the cells you want to format. Press Ctrl - 1 to open the Format dialog box and under the Number tab, you will have the various number formats. Then pick whichever one you want to use for the selected cells. The chosen formatting will be applied to those cells.

User Avatar

Wiki User

9y ago

Still curious? Ask our experts.

Chat with our AI personalities

BeauBeau
You're doing better than you think!
Chat with Beau
TaigaTaiga
Every great hero faces trials, and you—yes, YOU—are no exception!
Chat with Taiga
ProfessorProfessor
I will give you the most educated answer.
Chat with Professor
More answers

Spreadsheets are for working with and analysing numbers. So numbers are critical to Excel. They can be used for simple calculations and for much more complex ones. It could be for things like sales or statistics.

Spreadsheets are for working with and analysing numbers. So numbers are critical to Excel. They can be used for simple calculations and for much more complex ones. It could be for things like sales or statistics.

Spreadsheets are for working with and analysing numbers. So numbers are critical to Excel. They can be used for simple calculations and for much more complex ones. It could be for things like sales or statistics.

Spreadsheets are for working with and analysing numbers. So numbers are critical to Excel. They can be used for simple calculations and for much more complex ones. It could be for things like sales or statistics.

Spreadsheets are for working with and analysing numbers. So numbers are critical to Excel. They can be used for simple calculations and for much more complex ones. It could be for things like sales or statistics.

Spreadsheets are for working with and analysing numbers. So numbers are critical to Excel. They can be used for simple calculations and for much more complex ones. It could be for things like sales or statistics.

Spreadsheets are for working with and analysing numbers. So numbers are critical to Excel. They can be used for simple calculations and for much more complex ones. It could be for things like sales or statistics.

Spreadsheets are for working with and analysing numbers. So numbers are critical to Excel. They can be used for simple calculations and for much more complex ones. It could be for things like sales or statistics.

Spreadsheets are for working with and analysing numbers. So numbers are critical to Excel. They can be used for simple calculations and for much more complex ones. It could be for things like sales or statistics.

Spreadsheets are for working with and analysing numbers. So numbers are critical to Excel. They can be used for simple calculations and for much more complex ones. It could be for things like sales or statistics.

Spreadsheets are for working with and analysing numbers. So numbers are critical to Excel. They can be used for simple calculations and for much more complex ones. It could be for things like sales or statistics.

User Avatar

Wiki User

12y ago
User Avatar

It is not possible to answer this question because there are an infinite number of ways. For example, I could format 3.5 as "3.5", or "$3.50" or even as "Silly Format 3.5". Since there is no restriction on the text preceding (or following) the value, the number of options is infinite.

User Avatar

Wiki User

10y ago
User Avatar

It is very possible to answer this question. In Excel, there are a specific number of ways to format a number. For example, you can format it as not a number, called "General" which allows for text and numbers, i. e. "Silly Format 3.5." Then there are "Number" formats, where you can define the number of decimal places and whether or not to include a comma as a separator. Another example is Zip Code format.

Here is a list of all of the format categories supported in Excel 2013:

  • General
  • Number
  • Currency
  • Accounting
  • Date
  • Time
  • Percentage
  • Fraction
  • Scientific
  • Text
  • Special
  • Custom

Most of these categories have several formatting options as well.

User Avatar

Wiki User

10y ago
User Avatar

Spreadsheets are for working with and analysing numbers. So numbers are critical to Excel. They can be used for simple calculations and for much more complex ones. It could be for things like sales or statistics.

User Avatar

Wiki User

12y ago
User Avatar

Numbers can be formatted in these ways:

General

Number

Currency

Accounting

Date

Time

Percentage

Fraction

Scientific

Special

Custom

User Avatar

Wiki User

12y ago
User Avatar

GO TO THE MENU BAR "FORMAT" CHOOSE CELL, CHOOSE NUMBERS TAB

User Avatar

Wiki User

17y ago
User Avatar

Right-click on the cell (or range of cells) you want to format and select cell format. Use the options available in the cell format window to format the cell as you like.

User Avatar

Wiki User

15y ago
User Avatar

There are many ways to format numbers. Here are a few examples:

  • Currency ($123.34)
  • Date (12/12/2010)
  • Time (12:34)
  • Decimal (123.45)
User Avatar

Wiki User

14y ago
User Avatar

Add your answer:

Earn +20 pts
Q: What are some examples of number formats in Microsoft Excel?
Write your answer...
Submit
Still have questions?
magnify glass
imp