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