It shouldnt have cause if you select a cell, it should say '2010-11-12
The single quotation mark makes sure it puts it in as the text and not the date