Currency values in Excel to VB2005

  • Thread starter Thread starter zacks
  • Start date Start date
Z

zacks

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.
 
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.
Click to expand...

It's not really an invalid currency value. Have you tried pasting the value
into the cell?
 
Back
Top