Thanks Tom, that clarifies the matter.

-Minitman


On Tue, 14 Dec 2004 21:52:03 -0500, "Tom Ogilvy"
wrote:

Here is why

? val("$8.00")
0

Val stops evaluating at the first non-numeric character. That is why it
didn't work "right" with 8.00%. However, cdbl will accept and ignore the $,
but will cause an error with "8.00%"

Using cdec is overkill. It uses up 14 bytes to store a value and is
designed for huge numbers. Double (8 bytes) or single (4 bytes) is more
realistic: cdbl or csng