Hi

How do I programmatically set a cell to accept "1/1/1799" as a date.

If I pass it in and then reset the NumberFormat of the cell or the column it
continues to see it as a string,

e.g.
MySheet.Cell(1,1).NumberFormat = "dd/mm/yyyy"
MySheet.Cell(1,1).FormulaR1C1 = Cstr(DateValue("1/1/1799"))

So if I want to show it as 01-Jan-1799 it refuses(!) to see it as a date
and continues to show 1/1/1799

Thanks

Simon