K Kim-Anh Tran Apr 30, 2004 #1 How do I format cell allowing only number entry and give message fo retry? Thanks in advance for your help
How do I format cell allowing only number entry and give message fo retry? Thanks in advance for your help
T Trevor Shuttleworth Apr 30, 2004 #2 Use Data | Validation | Settings Tab | Allow: Whole number or Decimal. Then add a message to the Error Alert tab Regards Trevor
Use Data | Validation | Settings Tab | Allow: Whole number or Decimal. Then add a message to the Error Alert tab Regards Trevor