How to Insert a Date in Microsoft Excel

Save

Microsoft Excel has many options for entering numbers into cells. The default option in Excel is the "general" setting, which means that what you enter into the cell will be what is displayed. However, if you want to perform calculations on the data, Excel must be able to tell that what you are entering is an actual date. Excel allows you to enter dates in a variety of different formats. For example, December 25th can be entered as Dec-25 or 12/25.

Excel 2007

  • Right click on the cell and choose "Format Cells."

  • Click on the "Number" tab.

  • Click on "Date" in the "Category" list box.

  • Choose the date format by clicking on one of the formats in the "Type" box. For example, click on "3/14."

  • Press "OK."

Excel 2003

Tips & Warnings

  • Format an entire row or column of cells by clicking on the column identifier (the number or letter in the top of the column or far left of a row) before right clicking on a cell.

References

  • Photo Credit calendar with bow image by Photoeyes from Fotolia.com
Promoted By Zergnet

Comments

You May Also Like

Related Searches

Check It Out

Geek Vs Geek: Robot battles, hoverboard drag race, and more

M
Is DIY in your DNA? Become part of our maker community.
Submit Your Work!