Does anybody have a solution for this?

I really need it. I have been searching and trying to get this resolved for
days. I can't believe that i am the only one that ever had a problem
formatting numerics in a newly created Excel worksheet through VB 6.

I'm ready to turn this thing over to the client soon and it will not have
the numeric fields formatted properly.

Nobody else has had this problem in VB6? Where they put a string of numbers
into a cell and used the Numberformat = "###,##0.00_);[Red](###,##0.00)"
property. Then when they open the workbook the numbers are *not* formatted.

I guess my last resort would be to pay Microsoft support to help me rosolve
it.

Any help would be gratefully appreciated.

Thanks,
Tony

"Tony Girgenti" wrote in message
...
Hello.

I'm using VB6.0, SP6 and Excel 2003, SP3.

I'm formatting a worksheet column and then filling the columns with data.
The format gets applied, but the data is not appearing as expected. These
lines of code are what i am using to format the column with a Percent.

newExcelWorkSheet.Columns("D").NumberFormat = "0.00%"
newExcelWorkSheet.Columns("D").HorizontalAlignment = xlCenter

When i open the Excel workbook, the data is there and those cells show it
formatted as Percent with 2 decimals. The data is sent to the value of
the
cell as "015.00"(without the quotes), yet when open the workbook, it
appears
as 015.00. I was expecting it to appear as 15.00%.

The HorizontalAlignment works. Why is the data not appearing as a
percent?

If i open the workbook and put 015.00 in one of the formatted cells, it
does
appear as 15.00%.

Any help would be gratefully appreciated.

Thanks,
Tony