Limit Digits entered into a cell

G

Guest

I have a cell that users enter a 3 digit number and another a date, both are
used to generate a serial number. Is there a way so that if a user enters
more than 3 digits an error message comes up and it doesn't update to the
serial number cell? Thanks for any help
 
G

Guest

Mike,
Look at Data Validation==>Number and limit values to 100 to
999. You can your own "Error Alert" message.

Would this be OK?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Number of significant digits allowed in a cell is 15. 2
how to write 1234567890123456789 into a cell with number format 3
How to convert the values into 3 digits? 5
Type 3 digits in one cell then automatically move to next cell. 4
How many number digits can I fit into one cell? 3
I cannot enter a number containing more than 15 digits in Excel 1
Finding matching numbers from 1 worksheet in another and with a tw 1
Split a number in a cell into parts 4

Top