the format data - not formatted

N

nnv1

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 colum
format is defined!
Only if I do double click on a cell and Enter - the number becom
formatted.

How can I format apply format for ALL my data by usin
methods/properties of Excel.Application object (script), not re-ente
data into cells manually.
Thank you
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel does not accept text format! 0
Creating Multi Level list using Header Style 1
.find does not find if .NumberFormat = "#,##0.00" 2
Conditional Formatting Dates Less Than 14 Years Ago 2
Conditional Formatting - Selective Cell Highlighting 5
Macro to Format Multiple Sheets based on "Master" Format 0
Macros to convert Data into date format and then plot in graph 7
Count with formatting 1

Top