Convert numbers stored as text to numbers Errors after wri..

I'm trying to write data to excel from sql server.

Even thought I'm writing numerics, every cell gets this error with a
green tag:

Convert numbers stored as text to numbers

Cells were all pre-formated to accounting 2 decimal, and if i manually
type the exact data Im sending it formats just fine.

I'm hearing this a common problem.

On another project I was able to find a workwork for the web based
version of excell, by writing this to the top of the file:

<style>.text { mso-number-format:\@; } </style>

is there anything I pre-set or write to my file so that numerics are
seen as numerics and not text.
Maybe some setting in my write drivers - using sql servers excel
destination.

thanks for any help or information.

On Mar 28, 4:57 pm, "Nick Hodge"
<nick_hodgeTAKETHIS... RemoveThis @zen.co.uk.ANDTHIS> wrote:
> Not sure what setting to change. I would just copy a blank cell, highlight
> the data and select Edit>Paste special...>Values+add
>

I'm trying to create and populate an excel spreadsheet
programmatically from sql server.