Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
setting the font type for all comments on excel spreadsheets | Excel Discussion (Misc queries) | |||
Setting field size and type | Excel Discussion (Misc queries) | |||
Registry setting for default document type? | Excel Discussion (Misc queries) | |||
VBA setting formula for a cell causes "Wrong data type" error | Excel Discussion (Misc queries) | |||
Setting up a Custom type, User-defined, Default Chart | Charts and Charting in Excel |