(Msg. 1) Posted: Tue Mar 27, 2007 1:12 am
Post subject: Convert numbers stored as text to numbers Errors after writing to Excel Archived from groups: microsoft>public>excel>datamap (more info?)
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.
(Msg. 2) Posted: Wed Mar 28, 2007 7:03 pm
Post subject: Re: Convert numbers stored as text to numbers Errors after writing to Excel [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
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.TakeThisOut@zen.co.ukANDTHIS
www.nickhodge.co.uk
"jobs" <jobs.TakeThisOut@webdos.com> wrote in message
news:1174983178.025534.59640@b75g2000hsg.googlegroups.com...
> 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.
>
(Msg. 3) Posted: Wed Mar 28, 2007 10:33 pm
Post subject: Re: Convert numbers stored as text to numbers Errors after writing to Excel [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
On Mar 28, 4:57 pm, "Nick Hodge"
<nick_hodgeTAKETHIS....DeleteThis@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.
All times are: Eastern Time (US & Canada) (change)
Page 1 of 1
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Home
Forums
Home
FAQ
Profile
Private Messages
Log in
Office