well, I use something MUCH better!!!!!!
I use ROUND function and everything works just fine - take value and with
ROUND function you can round number to 10 decimal places (that's maximum
which excel uses for date/time format) and after that every calculation or
comparison will work just fine!!!!!
There is great difference between round function and number formatting

ENJOY!
"excelent" wrote in message
...
ok tks Dav
i got the address on this page to help out the problem looks fine

http://support.microsoft.com/kb/211830/en-us


"Dav" skrev:


Its a quirk in excel and the way it stores values. There have been many
threads discussing this, If you search for Jerry Lewis he seems to be
the person who understands it most

Regards

Dav


--
Dav
------------------------------------------------------------------------
Dav's Profile:
http://www.excelforum.com/member.php...o&userid=27107
View this thread:
http://www.excelforum.com/showthread...hreadid=564195