|First, please do not post in all caps. All caps is considered the internet equivalent of shouting and we don't like to be shouted at.|
Second, AlteK already answered your question.
010113 is not a date as far as Excel is concerned. It's just a number. However, if you format the cell as Date, it will convert that number into a date based on how Excel stores dates internally. It will use that number as the number of days since January 0, 1900 and display it in the Date format chosen.
To understand how Excel stores dates and times, see this site:
If you want to prove to yourself that your numbers are the equivalent of the Dates that Excel displayed, go to this site, scroll down and enter your numbers in the Excel Serial Day Number section, 1900 Date System field, then scroll back up and see the dates that are shown in the Gregorian Calendar. They will match the dates that Excel returned.
If you want 01/01/13 in a cell, then you need to enter the slashes. 010113 is not a date as far as Excel is concerned.
If you want 010113 in a cell, put a single quote in front of it, but don't expect Excel to treat it as a date.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.