Brian,

Please send the complete contents of that cell to produce the #. Did you
start it with an = or a - sign?

Rob

"Brian" wrote in message
...

When I change to cell's format to text it changes everything I typed in to
###############. I cleared it out and typed in again. I can only get about
one sentence bofore it turns to ########### but there is plenty of space
and
word wrap is on
"RobN" wrote:

Brian,

You can format all those cells as text by selecting all those cells and
going to HomeFormatFormat CellsNumber and select Text.
Then go to Excel Options and, in the Formulas section, untick "Numbers
formatted as text...."; to turn off the green error indicator.

Rob

"Brian" wrote in message
...
I have a workbook that has several worksheets init that are alike. They
populate averages for grades. But there are comment blocks for input
from
the
evaluators. Some evaluators like to make their comments in bullets and
use
"=" or "-" which turns on a green light for the formula to start
trying
to
figure out the formula and causing a big mess. Is there a way to format
certain cells to not allow formula?
Thanks