Microsoft Excel gives you a multitude of options for cell formats. Format a cell to display decimals to two places and Excel will round every input to two decimal places; format for fractions and Excel will display numbers in fractional form; format for date and Excel will convert every number you input to a date. If you are entering numbers into a cell and a date appears, all you need to do is format the cell and tell Excel what kind of number you are expecting to see in the cell.
Right-click on the cell.
Choose "Format Cells".
Click on the "Number" tab. Click on a number format that you would like. For example, choose "decimal".
Tips & Warnings
- Apply the formatting to a range of cells by clicking on a column or row identifier (for example, "A" or "1") and then right-clicking.
- Photo Credit keyboard image by Fyerne from Fotolia.com
How to Remove Duplicates from Excel Macro
A duplicate entry in Microsoft Excel is an entry in a column or row that matches other entries in the same column...
How to Convert Numbers to a Date in Excel
Microsoft Excel 2007 is a popular spreadsheet program that is filled with options to modify and display data. With this powerful tool,...
How to Remove Duplicate Values From a List in Excel
Excel lets you sort massive amounts of data in a spreadsheet. As your list grows, you may start receiving some duplicate values....
How Do I Remove a Word From Cells in Excel?
Large Excel workbooks sometimes contain dozens or even hundreds of occurrences of a specific word. Manually finding and changing each word in...
How to Edit a Cell
Users of Microsoft Excel will find that one of the most common tasks is editing cells. The data content of cells may...