Can you set max number of characters per cell in Excel '03?

M

mzehr

Rachel,
You can use Data Validation
Allow: Text length, then use 0 for your minimum, and set
your maximum to whatever you want. Copy this validation
setting to all affected cells.

Note though, that if a user pastes values into the cell,
it will override the data validation feature.

HTH
 
Top