Message
 

Hello
I have a cell that needs to have a 5 digit number enter into it. I
would like a message box or some other type of warning to let the
person know that it has to be a 5 digit number (not a 4 or 6 digit
number). How would be the easiest way to do this.

Thanks
JG

Message
 

Dayta/ Validation ...
--
David Biddulph

"JG" wrote in message
ups.com...
Hello
I have a cell that needs to have a 5 digit number enter into it. I
would like a message box or some other type of warning to let the
person know that it has to be a 5 digit number (not a 4 or 6 digit
number). How would be the easiest way to do this.

Thanks
JG

Message
 

Data/ Validation ...
--
David Biddulph

JG" wrote in message
ups.com...
Hello
I have a cell that needs to have a 5 digit number enter into it. I
would like a message box or some other type of warning to let the
person know that it has to be a 5 digit number (not a 4 or 6 digit
number). How would be the easiest way to do this.

Thanks
JG

Message
 

select the celldatavalidationtext lengthequal to 5
--
Don Guillett
SalesAid Software

"JG" wrote in message
ups.com...
Hello
I have a cell that needs to have a 5 digit number enter into it. I
would like a message box or some other type of warning to let the
person know that it has to be a 5 digit number (not a 4 or 6 digit
number). How would be the easiest way to do this.

Thanks
JG