Excel Currency problems

[v2ng at my-deja.com]

I'm having problems reading currencies formatted fields in Excel from
Python through COM.

If I type in a value (say : 941221.6) and format it in Excel to :

Currency, 2 decimal places, symbol = $, Negative numbers = -$1,234.10

In Python, I'll use the win32com.client modules and do:

        return sheet.Cells(row, col).Value

where sheet is the worksheet I'm using.

Python will return the following value:

(2, 822281408)

If I reformat the cell to General, everything seems ok.

Any ideas?
Vic


Sent via Deja.com http://www.deja.com/
Before you buy.