Not sure what setting to change. I would just copy a blank cell, highlight
the data and select Edit>Paste special...>Values+add
That'll boot them into action
--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
nick_hodgeTAKETHISOUT[ at ]zen.co.ukANDTHIS
www.nickhodge.co.uk
FREE UK OFFICE USER GROUP MEETING, MS READING, 27th APRIL 2007
www.officeusergroup.co.uk
"jobs" <jobs[ at ]webdos.com> wrote in message
news:1174983178.025534.59640[ at ]b75g2000hsg.googlegroups.com...
[Quoted Text] > 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:\[ at ]; } </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.
>
|