From excel 2007 we have got a provision to unzip and get the set of XML files.Each sheet has its own xml file.

In a sheet xml file,we found that the sheet data is represented with some tags
e.g.
<sheetData>
<c r="F3" s="5" t="s">
<v>13</v>
</c>
</sheetData>

Here in above tag, t represents cell type content which is a enumeration of values {e,s,n,b,inlinestr}.

we are able to replicate all the above values except "n" by entering values in excel sheet and opening it again with winzip.
n here represents number but we could not replicate this one.
Can someone please let us know how to do it?