>Hi Cetin,
>
>>A friend of mine asked this to me today. I said yes,0 with confidence and he said OK then go and put that in Excel as a formula.
>>I thought it was an Excel bug but he turned and said it happens in SQL server with float datatype! I couldn't yet see that myself but trust his experience.
>>Any idea and solution?
>>TIA
>>Cetin
>>When I put this formula in Excel the result's -2,77556E-17, but if I format the cell to number, the result's 0. When do you format cell to number the same occcur?
>Btw, Congrats for Personality!
Erick,
Real concern was not excel or display format, it was only the simpliest way I thought to show the problem. .Net, C, SQL server also have the same problem.
Cetin