answersLogoWhite

0

Data can take different formats. For example, numbers can be displayed with or without decimal points or as currency or percentage and other formats. Dates can be shown with just numbers or with words for the month and the day, or showing month, then day or day, then month. So all of these things are formatting. There are many data types and they can be formatted in different ways to suit what the user of the spreadsheet wants.

User Avatar

Wiki User

12y ago

What else can I help you with?

Related Questions

What is the default that excel applies to number?

general format


What style is the format style that excel assigns to all cells in a work book?

The default format style that Excel assigns to all cells in a workbook is the General format. This format displays numbers as they are entered and adjusts automatically based on the content of the cell.


What are the formats for displaying numbers in a cell?

There are many different formats for displaying numbers in an Excel cell including a general format, a currency format, a percentage format and an accounting format.


What is the default format that Excel applies to numbers trailing zeros to the right of a decimal?

Answer: The default setting is no zeros are automatically added to the right of a decimal point. You need to set the format of the cell if you want a specific numbe of places to display to the right of the decimal point. Answer: In Excel, the default format is called "General".


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.


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.


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.


If the format you need is not available in any of the predefined formats offered in excel you can create a general format?

You can create many types of custom formats. Just go to Format Cells | Number | Custom to create your custom format.


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.