Recognising a date format in an worksheet.xml

I am currently trying to read an excel spreedsheet into an xml model that we have created. I am reading the worksheet.xml fine and I can determine when the value in the cell is in a boolean or string format. I cannot easily however find a programatic way to distinguish between whether a value is a serialized date or a number.

My firstthoughts was that you could do this through the style.xml page and that it has something to do with the field 'numFmtId' in the node 'cellXfs'. If so is there a standard list of all the available numFmtId allowed? Can anyone please help.

Thanks

Steve

[697 byte] By [scifigooner] at [2008-2-24]
# 1

Did you see the attribute "s" into the cell node?

This is a date:

<c r="E1" s="1">
<v>40000</v>
</c>

==> (s="1")

MauricioG at 2007-10-2 > top of Msdn Tech,Office Live Development,Microsoft SDK for Open XML Formats...