Thanks for the Ideas, but neither worked.
But, the next response did.
Joe
-----Original Message-----
One thing clicked when you said you double-click in the
cell and then do
nothing, hit return and it doesn't work. I've had a
similar thing
happen. I'll use a formula to split a number from a
different cell
(e.g., =LEFT(A1, 10)). Then, I paste special values the
cell containing
the formula. That value will be left-aligned and treated
as text, until
I double-click the cell and hit return. So, the reason
your formula
doesn't work, I imagine, is because it's trying to
compare a cell with a
number with a cell with text. Try putting VALUE()
functions in or
Cint() functions.
Please let me know if this works, as I am interested in
finding the
cause of this problem!
---
Mark Bigelow
mjbigelow at hotmail dot com
http://hm.imperialoiltx.com
*** Sent via Developersdex http://www.developersdex.com
***
Don't just participate in USENET...get rewarded for it!
.