Number of character in one cell.
 

How should I set if there is dialog showed that:

The text string you entered is too long. Reduce the number of characters
used or cancel the entry.

and I can't click anything for adjustment?

Number of character in one cell.
 

Look under datavalidation, allowtext length, then select error message

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey


"Aom" wrote in message
...
How should I set if there is dialog showed that:

The text string you entered is too long. Reduce the number of characters
used or cancel the entry.

and I can't click anything for adjustment?