Excel 2013 can do a very good job of automatically detecting the type of information that you have entered into a cell. Unfortunately it does not always guess