news:1141229041.810056.25170@i40g2000cwc.googlegroups.com...

>I am using the Microsoft Excel driver (DriverID 790) to process data in
> an Excel spreadsheet. One of the columns is money, but was orinally
> formatted as General. So a value in the spreadsheet of say 462.97 came
> into the application as 462.969999999999, which is of course an invalid
> value for currency, not only to say not the correct monetary value.
> Changing the format of the cells to currency fixes the value and of
> course looks fine in Excel. But now when I read the value in, it comes
> in as 462.9700. Still an invalid currency value even if the extra
> decimal places are always zero. So now I have to account for those
> extra zeros and ignore them, which I do not like having to do. Is this
> a known bug in the driver? Is it fixable? I tried all different
> combinations of cell formatting I could think of, but nothing helps.