close

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 = quot;_-* #,##0.00$_-quot;

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 - www.officehelp.in

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()

    E-mail轉寄