answersLogoWhite

0


Best Answer

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

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

Wiki User

11y ago

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.

This answer is:
User Avatar

User Avatar

Wiki User

9y ago

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.

This answer is:
User Avatar

User Avatar

Wiki User

9y ago

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.

This answer is:
User Avatar

User Avatar

Wiki User

11y ago

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.

This answer is:
User Avatar

User Avatar

Wiki User

11y ago

Numbers can be formatted in these ways:

General

Number

Currency

Accounting

Date

Time

Percentage

Fraction

Scientific

Special

Custom

This answer is:
User Avatar

User Avatar

Wiki User

17y ago

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

This answer is:
User Avatar

User Avatar

Wiki User

14y ago

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.

This answer is:
User Avatar

User Avatar

Wiki User

14y ago

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)
This answer is:
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
Related questions

What does number mean in Microsoft Excel?

Number can be just the mathematical term for a number. In Excel it is also a category for various formats for displaying numbers like currency, percentage etc.


How many file formats does Excel offer for saving a workbook?

Microsoft Excel offers more than 30 file formats for saving a workbook. Iif you go to Save As and bring up the list in the "Save as Type" field, it will show you all the available options for your version of Excel.


What format is used to display non-currency numbers?

There are a number of formats in Excel that can be used other than currency and accounting, like percentage, fraction, general, scientific and number. Date and Time formats can also be applied to numbers.There are a number of formats in Excel that can be used other than currency and accounting, like percentage, fraction, general, scientific and number. Date and Time formats can also be applied to numbers.There are a number of formats in Excel that can be used other than currency and accounting, like percentage, fraction, general, scientific and number. Date and Time formats can also be applied to numbers.There are a number of formats in Excel that can be used other than currency and accounting, like percentage, fraction, general, scientific and number. Date and Time formats can also be applied to numbers.There are a number of formats in Excel that can be used other than currency and accounting, like percentage, fraction, general, scientific and number. Date and Time formats can also be applied to numbers.There are a number of formats in Excel that can be used other than currency and accounting, like percentage, fraction, general, scientific and number. Date and Time formats can also be applied to numbers.There are a number of formats in Excel that can be used other than currency and accounting, like percentage, fraction, general, scientific and number. Date and Time formats can also be applied to numbers.There are a number of formats in Excel that can be used other than currency and accounting, like percentage, fraction, general, scientific and number. Date and Time formats can also be applied to numbers.There are a number of formats in Excel that can be used other than currency and accounting, like percentage, fraction, general, scientific and number. Date and Time formats can also be applied to numbers.There are a number of formats in Excel that can be used other than currency and accounting, like percentage, fraction, general, scientific and number. Date and Time formats can also be applied to numbers.There are a number of formats in Excel that can be used other than currency and accounting, like percentage, fraction, general, scientific and number. Date and Time formats can also be applied to numbers.


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


Match examples of number entries to the number formats you would use to represent them in Excel 2007 All formats may not be used?

Fraction >> 8/10 Currency>>-$66,198.05 Number>>-8547.54 Scientific >> Time>>12:51:37 Accounting>>99,178.98


What is the bottom number on Microsoft Excel?

The last row number for Excel 2007 is 1048576.


Total number of column in Microsoft Excel?

The total number of columns in versions of Excel up to Excel 2003 is 256 columns. The total number of columns in Microsoft Excel 2007 and onwards is 16384. The total number of rows up to Excel 2003 is 65536. From Excel 2007 it is 1048576.


Is System software is a collection of programs?

One of the examples of this is Microsoft excel


Is Excel an example of an application software?

No. It is an example of spreadsheet software.


Are Microsoft Excel files transferable from mac to PC?

Excel provides formats that allow you to save files on a PC to be used on a Mac or on a Mac to be used on a PC, so the answer is yes.


Microsoft Word and Excel are example of system software?

No. They are examples of Applications software.