Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Format Problem - Date Overrides Format | Excel Discussion (Misc queries) | |||
General Format to Custom format problem | Excel Discussion (Misc queries) | |||
if format problem | Excel Worksheet Functions | |||
Format Problem | Excel Programming | |||
Format Problem | Excel Discussion (Misc queries) |