[Tutor] Excel

Terje Johan Abrahamsen terjeja@hotmail.com
Wed, 26 Jun 2002 16:32:49 +0000


I am trying to change the numberformat on a collumn in Excel.

>>>xl = xlApp.Workbooks(1).Sheets(1)

So when I type
>>>xl.Columns(5).Style.NumberFormat
>>>u'General'

So far so good.

Then I type:
>>>ffac.xl.Columns(5).Style.NumberFormat = "##.##"
>>>ffac.xl.Columns(5).Style.NumberFormat
u'$00.00'

So, I assume that the value in the cells should have changed to number, but 
it hasn't. They are still formated as "general" if I check in Excel. If I 
write ffac.xl.Range("E5").Value I get up the correct value, so I must be 
working with the correct sheet.

How can I change the format of the cells?

_________________________________________________________________
Send and receive Hotmail on your mobile device: http://mobile.msn.com