I need to put a date in a cell, when I take a look to its format it looks like \*14/03/01.

The value I put is a simple string and for that reason when I get the calculated values ignores the date I entered because it compares in a calendar (well, a column with all the dates of the actual year) the date that I entered with the dates to set a proper value corresponding the date entered.

Is there a way to put the format that Excel expects?