Gee...I had no idea what excel could do. I am trying to learn access, I can
see excel is just as powerful and challenging.

Thanks everyone. I finally got it!

Linda

"Max" wrote in message
...
Try: =TEXT(COUNT(B2:G2)/6,"0%")

As you probably mean to concat a text phrase to the percent result,
so maybe something like:
=TEXT(COUNT(B2:G2)/6,"0%")&" of 6"
would be closer to what you're after
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----