Setting data type

M

McEve

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...?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cell data entering slow! 0
Internal Data Integrity (Type 4) Details Needed 1
Create timeline with event being hyperlinks to documents on drive 1
Number stored as text 4
Macros to convert Data into date format and then plot in graph 7
Forcing Excel to Import .CSV data 2
Update this macro to make it generate a counter as text 7
Help with loop 4

Top