How to keep Excel 2007 from Auto Formatting dates

In this video tutorial we will show you how to keep excel from auto formatting dates.


In order to keep excel from auto formatting dates, open the Microsoft Excel. For example, type “05/03/2011” in A1 cell. As you can see excel auto formatted the date. To prevent it, right-click on A2 cell and choose “Format Cells”.

Auto format the date in the cell

In the “Number” tab select “Text” and press “ok”.

Select the auto format type

Now type “06/03/2011”. As you can see, excel did not format the date.