Ron,

What I found out now is that when an amount is 66.60 Excel will cut of the
trailing zero and the result of your formula will be 66.F
I should be 66.6{
I could change the format of the cell to text but then the negative amounts
are no longer recognized.

Any ideas?

Thanks,

Bram.

Ron Rosenfeld wrote:
Thanks Dave and Ron.
Your formulas both work great!!

Bram.

You're welcome. Thanks for the feedback.

--ron

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200511/1