| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
forcing cell format type in excel using com?
I have a program that creates and inserts into an excel document using com.
The default format for the cells are type=general. I need to force it to type=text so excel doesn't try formatting my data. I can't find any documentation on how to do this, any suggestions? ex. 179662E14 displays as 1.80E+19 note: sometimes this data views differently because the column is not open wide enough, but this is a different issue. thanks, Daryl |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
forcing cell format type in excel using com?
ActiveCell.Numberformat = "@"
-- Regards, Tom Ogilvy "Daryl" wrote: I have a program that creates and inserts into an excel document using com. The default format for the cells are type=general. I need to force it to type=text so excel doesn't try formatting my data. I can't find any documentation on how to do this, any suggestions? ex. 179662E14 displays as 1.80E+19 note: sometimes this data views differently because the column is not open wide enough, but this is a different issue. thanks, Daryl |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Forcing Save as in the format of Excel 2007 | Excel Discussion (Misc queries) | |||
| Format Cell As You Type | Excel Programming | |||
| Find the Format Type of a cell | Excel Programming | |||
| Change Excel cell format date type examples ("14-Mar-01") | Setting up and Configuration of Excel | |||
| Variant type for Excel cell percentage data format | Excel Programming | |||
Hybrid Mode
