Thread: Format problem
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bob McClellan[_2_] Bob McClellan[_2_] is offline
external usenet poster
 
Posts: 2
Default Format problem

Hello,
I am updating a spreadsheet as a linked table
from an SQL Stored procedure. No matter how I send
in the data, and no matter how I try to force the format of the
cells.... it continues to show as text. all values have the 'to the left
of the number, rendering them as text.

Is there a way to combat this...?
Everything works, the data all goes where it is supposed to go...
I just want it to be numeric... NOT text

...this is the create table sql
exec spExecute_ADODB_SQL
@DDL='Create table ExecUtilHistoryDetailed
( id int
, Header char(20)
, cccID int
, ClassDesc Char(50)
, d1 DECIMAL(9,2)
, d2 DECIMAL(9,2)
, d3 DECIMAL(9,2)
, d4 DECIMAL(9,2)
, d5 DECIMAL(9,2)
, d6 DECIMAL(9,2)
, d7 DECIMAL(9,2)
, d8 DECIMAL(9,2)
, d9 DECIMAL(9,2)
, d10 DECIMAL(9,2)
)'
, @DataSource
='C:\Mail.Files\Utilization\Utilization.Executive. Summary.V3.xls'

thanks.
bob.