Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Setting data type

Hello,

I am generating an Excel file from ASP, with data from SQL. I have no
problem generating the file using Server.CreateObject("OWC.Spreadsheet")

The problem I'm facing is that Excel is guessing the data type, and guessing
"wrong".... I need column G to be data type text, even though it is numbers
in this column. Several of the numbers that goes into this column starts
with one or more zero's, which disappear when Excel assumes the column
should be formatted as data type number.

Is there any way I can over ride the data type, so that I can get the
numbers right? (they are zip codes).

A "Public Property Let" value...?


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
setting the font type for all comments on excel spreadsheets Delquestion Excel Discussion (Misc queries) 3 October 8th 09 02:21 PM
Setting field size and type tsap Excel Discussion (Misc queries) 1 December 13th 07 11:05 PM
Registry setting for default document type? Ann Scharpf Excel Discussion (Misc queries) 1 July 26th 07 06:40 PM
VBA setting formula for a cell causes "Wrong data type" error undercups Excel Discussion (Misc queries) 4 September 17th 06 10:14 PM
Setting up a Custom type, User-defined, Default Chart Kurt Charts and Charting in Excel 0 December 22nd 05 07:43 PM


All times are GMT +1. The time now is 06:50 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"