How to Convert Numbers to a Date in Excel

by Stephanie Ellen

Microsoft Excel 2007 is a popular spreadsheet program that is filled with options to modify and display data. With this powerful tool, it's possible to display numbers as decimals, fractions, whole numbers and a wide variety of date styles. The menu to change decimal numbers to dates can be accessed through the "Data" tab, which controls how information is presented.

1

Highlight the cells you would like to convert to date format. Select the cells by left clicking and mousing over the cells.

2

Click the "Data" tab.

3

Select the "Text to Columns" button.

4

Click "Next" twice, bypassing the options for changing the delimited or fixed width values.

5

Select the "Date" radio button.

6

Choose the date format from the drop-down menu: MDY,DMY,YMD,MYD,DYM,YDM.

7

Click the Finish Button.

Tip

  • check It's easier to format cells before you enter the dates rather than try to modify dates afterward.

Items you will need

About the Author

Stephanie Ellen teaches mathematics and statistics at the university and college level. She coauthored a statistics textbook published by Houghton-Mifflin. She has been writing professionally since 2008. Ellen holds a Bachelor of Science in health science from State University New York, a master's degree in math education from Jacksonville University and a Master of Arts in creative writing from National University.