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

13y 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.

Trending Questions
What is a good gaming rig for under 700? What of the operating system enables users to communicate with the computer system? What is the best book to learn how to use Adobe Photoshop CS4? How is the CPU linked to the primary storage and other devices in the computer system? Let 01111 be the frame delimiter flag in a data link protocol What is the transmitted bit sequence for the data 0111110111011110 using the bit stuffing method? What are four things and or groups of people you feel have been on the receiving end of prejudice? What is 15.5cm in mm? What is the floating point unit used for on the processor system? What is the best way to clean up ink or toner spills? Does an iMac come with a photography program? How do you construct 3 input XOR gate with 2 input XOR gate? Which two interfaces will allow access via the VTY lines to configure the router? How do you get free bricks on lego.com? Transunion fax number? What is difference between amd dual-core e-350 and AMD dual-core E-450 e-450? What is the hard-hit line drive? What type of maintenance is required of a computer's power-supply to ensure that it remains in working order? There is an antivirus software trying to be installed in my computer How do you remove it. The name of the antivirus software is Personal antivirus. I cannot see it in the control panel? Why does 'error 1068 the dependency service or group failed to start' appear when starting Norton's Ghost 9 in Windows 2000? What is the difference between 320GB and 500GB?