Excel Number Formats

Ace your homework & exams now with Quizwiz!

Accounting

Displays numbers in the Currency format but lines up the dollar signs and the decimal points vertically within a column.

Currency

Displays numbers preceded by a dollar sign with a thousands separator and two decimal places.

Number

Displays numbers with a fixed number of places to the right of the decimal point; the default is two decimal places

Special

Displays numbers with a specific format: zip codes, zip+4 codes, phone numbers, and Social Security Numbers

Percentage

Displays numbers with two decimal polaces followed by a percent sign

Text

Displays text and numbers exactly as you type them.

Date

Displays texts and numbers as dates

Time

Displays texts and numbers as time

Custom

Displays data in the formay you create,such as with commas or leading zeros

Fraction

Displays decimal numbers as fraction

Scientific

Displays numbers in explonential (or scientific) notation

General

The default format; displays numbers as typed. If the number doesn;t fit in the cell, decimals are rounded, or the number is converted to scientific notation.


Related study sets

HEALTH ASSESSMENT: ASSESS HEAD/NECK

View Set

Flowers For Algernon Synonyms and Antonyms

View Set

Final Exam Review HR - MGMT 3860

View Set

Critical Thinking/Reading; What is Ethics?

View Set

M.32: Dynamic Study Module Postpartum Adaptation and Nursing Assessment

View Set

Med Surg - Chapter 58 - Care of Patients with Liver Problems

View Set

Psychology (Stress and Heart Disease)

View Set