Is there a format I can set so that excel will not convert a number to Scientific Notation? If I have a cell set to number datatype and the number is 11+ digits long, excel converts the number to Scientific Notation which I do not want.
I went into Excel and was able to set the cell formatting so that it did not show scientific notation when using the Number format. I then saved the spreadsheet and examined the style. Looks like numFmt 1 does the trick. In XML, that style looks like this:
<xf numFmtId="1" fontId="0" fillId="0" borderId="0" xfId="0" applyNumberFormat="1"/>
Awesome! Thanks bobm.