Added decimal places

[bethj3]

In my tables my number values look right, but when I use a query to to
subtractions, I'm getting slightly wrong numbers. For example, I have begin and
end values. If I enter 0.51 and 0.63, when they are subtracted I should get
0.12. Instead I'm getting values like and 0.1199998856 or 0.1200000048. I have
the field values set as Number and Single, but have tried a few other things.
Changing the decimal places shown, doesn't change the underlying value.
The only solution I can find is to use Currency for the Data Type instead of
Number, but this seems really strange. Anyone know why this is happening and
/or how to fix it?
Thanks!

[Dan Bracuk]

Why don't you just use the numberformat function to display your answers? Details are in the cfml reference manual. If you don't have one, the internet does.