Friday, February 24, 2012

Export to Excel - Number formatted cells export to Excel as 'General' ?

Anyone know why cells within a matrix that are formatted as numeric export to Excel with a cell format proprty of "General"? Cells within a table however export with an appropriate format.

Thanks

Try converting the data within the cell - something like cdbl() or cint() may work.

No comments:

Post a Comment