number format

How figures display

Number format is the way numerical values are displayed—including decimal places, thousands separators, currency symbols, or percentages.

Spreadsheets and databases let users choose number formats: Change the number format to show two decimal places.

The same underlying value can appear as "1000," "1,000," "$1,000.00," or "1E3" depending on the format applied.

Related

data type · fixed-point · integer · Roman numerals · metric system · scientific notation · locale · imperial system · percentage · social security · credit card · decimal · significant figures · leading zeros · place value · decimal

Opposites
representation vs. value

number formatactual value

True monetary amount

quantity · raw data

number vs. text

number formatdate format

How calendar entries are written

plain text · raw input

Family

number, format, numbers, numbered, numbering, numberless, innumerable, numeral, numerate

Familiarity
Top 500,000
Profile
Used worldwide · Timeless · Rated G