The format string which will help the value be interpreted as text is "@", as it is used in the following snippet:
CellSelection selection =
The reason why the format is applied before the value is set is that if you do it the other way around, you will get the numeric value of the date (41276), instead of the string you entered (1/1/2013), which is consistent with the behavior of Excel.
Check out Telerik Analytics, the service which allows developers to discover app usage patterns, analyze user data, log exceptions, solve problems and profile application performance at run time. Watch the videos
and start improving your app based on facts, not hunches.