Are you sure you formatted the cell as "text"? When I format a column
as text and enter a date it surely doesn't do any formatting.

But if you type an apostrophe preceding the date it should treat it as
text anyway.

Hans