| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
the format data - not formatted
Hi, Could you help me? I have an excel file with data daily imported from SQL via DTS. I want to format number data. I have a custom format for a column _-* #,##0.00$_- I define it in ActiveX task as objXL.Columns(11).NumberFormat = "_-* #,##0.00$_-" And I want to see 92.00$, but I see only 92, although the column format is defined! Only if I do double click on a cell and Enter - the number become formatted. How can I format apply format for ALL my data by using methods/properties of Excel.Application object (script), not re-enter data into cells manually. Thank you. -- nnv1 Posted from - http://www.officehelp.in |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cell data format | Excel Discussion (Misc queries) | |||
| Format columns if data in Col A | Excel Discussion (Misc queries) | |||
| How do I copy data in single cell format to a merged cell format | Excel Discussion (Misc queries) | |||
| excel data label format special number characters (part 2) | Excel Discussion (Misc queries) | |||
| Line Graph Data Recognition | Charts and Charting in Excel | |||
Linear Mode
