Ron,

Thanks for this info. It helps explain why I find strange values in my axis
limits for my charts. (I see the same effect there) Have been using round
functions and stuff to avoid it when changing the axis settings by code.

--
sb
"Ron Rosenfeld" wrote in message
...
On Thu, 21 Aug 2003 22:47:25 +1000, IM wrote:

I use a text-box in a form to enter numerical data. When I enter a
number, say, 14.6, in the text-box and then have the VBA code transfer
the data to my spreadsheet. Sometimes, but not always, the number shown
on the spreadsheet is not exactly 14.6, but 14.59999987..

Of course, I could add a few lines to the code to round the number off
to 2 or 3 decimal places. But there must a better way. What is it ? Why
does this happen ?

It happens because VBA of precision limits in VBA and/or Excel; and due to
the
fact that certain numbers cannot be represented exactly in binary. An
example
in decimal arithmetic would be the attempt to represent 1/3 in decimal
format.

There are several solutions depending on your goals:

Use the DECIMAL data type.
Round.
Use an appropriate number format in the Excel cell (this would leave the
result
as 14.5999999... but display it as 14.60).


--ron