Maximum character for cells 1

[Poweruser99]

I want one column on my spreadsheet to be 40 characters max. Can someone help me with how to achieve this. There is no built in functionality in Excel that would allow you to do this.

What I want is that everytime a user enters a value in the cell, they should get a prompt saying that they have exceeded the 40 max characters rule.

All help with will appreciated.

 

[PHV]

Take a look at menu Data --> Validation

Hope This Help, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884