If you enter it prior to specifying the formatting you are entering it as a date. The number you see when you change to text is the numeric value reflecting the

If you enter it prior to specifying the formatting you are entering it as a date. The number you see when you change to text is the numeric value reflecting the date/data you entered.