[python-win32] Problem about formatting a cell in Excel

[Lu Zheng]

Hi, all,

I am trying to copy some strings from a txt file into Excel. And I found that,
when I do this:
       'xlWorksheet.Cells(a, b).Value = "%1"', 
excel will format the string "%1" to "1%" when display and the actual value
becomes 0.01

How can I turn this autoformatting thing off so that "%1" will remain "%1"?

Thanks for your help :p

Regards,
Lu Zheng