Visual C# Developer Center > Visual C# Forums > Visual C# General > writing a DateTime cell in a spreadsheet, XML format
Ask a questionAsk a question
 

Answerwriting a DateTime cell in a spreadsheet, XML format

  • Wednesday, November 04, 2009 4:29 AMJon Q Jacobs Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    My C# app put this cell in a row:
    <ss:Cell><ss:Data ss:Type="DateTime">2007-07-06T00:00:00.000</ss:Data></ss:Cell>

    when I load the file in Excel, I see the value as 39269.

    What do I need to put into the cell so that it displays properly.

    If I need to post this on a different forum, please link me to it.

    Thanks,
    Jon

Answers

All Replies