Norm:

I tried your suggestion and clicked on the "match entire cell contents"
checkbox on the Search form, but still no-go. Did not find "$2.00" where I
entered 2.00 but Excel truncated it to "2".

I did find that if I preceeded the "2" with the literal key " ' ", that I
could force it to retain the trailing decimal and double-0, but it seems like
a lot of bother. I can't help but feel that the search function was written
by one coder and the rules for retaining data in the cell by somebody else
and they weren't talking to each other.

Thanks for trying to help.

Steve

"Norman Jones" wrote:

Hi $N.00?_Excel,

It's not ideal since if I due a search
all for 123.00 and 0.123, I get hits on both.

If you select the "Find entire cells ony" option, only the first value will
be found,


---
Regards,
Norman



"$N.00?_Excel" wrote in message
...
Dave

Thanks for your interest. You are correct in guessing that the Excel
input
window truncates the number to the significant digits and drops the
decimal,
even if I key enter these characters. It's not ideal since if I due a
search
all for 123.00 and 0.123, I get hits on both.

But the real problem, so to speak, is that if I search for 123.00, I get
no
hits at all. The search function is applying my search key literally and
is
not smart enough to realize that that a hit on "123" might be the right
answer.

Any ideas how to live with this or make it work better?

Thanks

Steve