answersLogoWhite

0

What does format mean in Excel?

Updated: 10/3/2023
User Avatar

Wiki User

14y ago

Best Answer

When you format a cell in Excel, you change the appearance of a number without changing the number itself. You can apply a number format (0.8, $0.80, 80%, etc) or other formatting (alignment, font, border, etc).

User Avatar

Wiki User

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

Wiki User

11y ago

It is changing how things look, like changing the size of text or bolding it or putting it in italics or underlining it or changing its colour. It can also be changing numbers to present them in other formats such as currency or percentages, or having certain amounts of decimal places. Dates and times can be shown in different ways, like having the month shown as a number or as text, or having times showing seconds or not. So formatting can cover a wide range things.

It is changing how things look, like changing the size of text or bolding it or putting it in italics or underlining it or changing its colour. It can also be changing numbers to present them in other formats such as currency or percentages, or having certain amounts of decimal places. Dates and times can be shown in different ways, like having the month shown as a number or as text, or having times showing seconds or not. So formatting can cover a wide range things.

It is changing how things look, like changing the size of text or bolding it or putting it in italics or underlining it or changing its colour. It can also be changing numbers to present them in other formats such as currency or percentages, or having certain amounts of decimal places. Dates and times can be shown in different ways, like having the month shown as a number or as text, or having times showing seconds or not. So formatting can cover a wide range things.

It is changing how things look, like changing the size of text or bolding it or putting it in italics or underlining it or changing its colour. It can also be changing numbers to present them in other formats such as currency or percentages, or having certain amounts of decimal places. Dates and times can be shown in different ways, like having the month shown as a number or as text, or having times showing seconds or not. So formatting can cover a wide range things.

It is changing how things look, like changing the size of text or bolding it or putting it in italics or underlining it or changing its colour. It can also be changing numbers to present them in other formats such as currency or percentages, or having certain amounts of decimal places. Dates and times can be shown in different ways, like having the month shown as a number or as text, or having times showing seconds or not. So formatting can cover a wide range things.

It is changing how things look, like changing the size of text or bolding it or putting it in italics or underlining it or changing its colour. It can also be changing numbers to present them in other formats such as currency or percentages, or having certain amounts of decimal places. Dates and times can be shown in different ways, like having the month shown as a number or as text, or having times showing seconds or not. So formatting can cover a wide range things.

It is changing how things look, like changing the size of text or bolding it or putting it in italics or underlining it or changing its colour. It can also be changing numbers to present them in other formats such as currency or percentages, or having certain amounts of decimal places. Dates and times can be shown in different ways, like having the month shown as a number or as text, or having times showing seconds or not. So formatting can cover a wide range things.

It is changing how things look, like changing the size of text or bolding it or putting it in italics or underlining it or changing its colour. It can also be changing numbers to present them in other formats such as currency or percentages, or having certain amounts of decimal places. Dates and times can be shown in different ways, like having the month shown as a number or as text, or having times showing seconds or not. So formatting can cover a wide range things.

It is changing how things look, like changing the size of text or bolding it or putting it in italics or underlining it or changing its colour. It can also be changing numbers to present them in other formats such as currency or percentages, or having certain amounts of decimal places. Dates and times can be shown in different ways, like having the month shown as a number or as text, or having times showing seconds or not. So formatting can cover a wide range things.

It is changing how things look, like changing the size of text or bolding it or putting it in italics or underlining it or changing its colour. It can also be changing numbers to present them in other formats such as currency or percentages, or having certain amounts of decimal places. Dates and times can be shown in different ways, like having the month shown as a number or as text, or having times showing seconds or not. So formatting can cover a wide range things.

It is changing how things look, like changing the size of text or bolding it or putting it in italics or underlining it or changing its colour. It can also be changing numbers to present them in other formats such as currency or percentages, or having certain amounts of decimal places. Dates and times can be shown in different ways, like having the month shown as a number or as text, or having times showing seconds or not. So formatting can cover a wide range things.

This answer is:
User Avatar

User Avatar

Wiki User

11y ago

Simpley its telling excel what type of data is in the cell and to make it look like it would on paper. for example setting the date format to USA or UK. The uSa have their date written as Month/day number/year and the UK have it as day number/month/year. You may want to tell the cell to show a dollar sign infront of the money value you put in the cell so everyone knows its a cash figure or to have it as black if the number is positive (youve mony in the bank) or red if you have a minus figure in the bank

This answer is:
User Avatar

User Avatar

Wiki User

11y ago

It is changing how things look, like changing the size of text or bolding it or putting it in italics or underlining it or changing its colour. It can also be changing numbers to present them in other formats such as currency or percentages, or having certain amounts of decimal places. Dates and times can be shown in different ways, like having the month shown as a number or as text, or having times showing seconds or not. So formatting can cover a wide range things.

This answer is:
User Avatar

User Avatar

Wiki User

14y ago

Formatting assigns specific characteristics to a cell. There are many ways you can format a cell. Some common types of formats include:

  • Bold [make the cell characters bold]
  • Date [display the cell contents formatted as a date]
  • Currency [display the cell contents formatted as currency]
  • Time [display the cell contents formatted to look like the time]
  • Custom [formatted how you choose]
This answer is:
User Avatar

User Avatar

Wiki User

14y ago

One meaning is a setting that determines how an entry is displayed in a cell. Examples are: time, bold, currency, center align, etc.

This answer is:
User Avatar

User Avatar

Wiki User

11y ago

i have no clue thats wat im trying 2 find out

This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: What does format mean in Excel?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

What format is Excel in?

MS Excel 2003 and earlier use the XLS format. MS Excel 2007 and later use the XLSX format.


How can I convert PDF to excel for free?

Well, I would recommend converting PDF format files to excel format files with a PDF format file to excel format file converter. There are many PDF format file to excel format file converters offered for use.


Format cell in Excel?

To format a cell in excel right click on it, then on the thing that pops up click on format cell


What is xls file format?

A document that is created by Microsoft Excel. Excel is a spreadsheet maker.


What are valid format symbols in Excel?

Excel does not use format symbols.


What is the default file format of Excel 2003 and 2007?

Default file format for Excel 2003: .xls Default file format for Excel 2007: .xlsx Note: You can't open lower version file format in upper version. If you want to do this then you will have to download the compatibility pack.


When you type numbers in a format that excel recognizes excel automatically applies format to the cell true or false?

False


The default format for a number typed into Excel is the format?

All numbers in Excel are actually decimal values (stored at the lowest level). The default is a best guess of how you typed it. Dates, numbers, etc. Remember - The format doesn't mean much of anything.. what's stored there remains the same.


What does excel immediately display with assigned format?

Format Symbol


How many different format choices are there for time in Excel?

In MS Excel 2010, there are 8 ways to format Time Cells


How do you write test scenarios on a xls format?

XLS is the file extension for MS Excel 2003 and earlier. If you want to save something in XLS format, then put the scenario data in Excel and save in Excel 2003 format.


Can you format dates in Excel?

yes