Use Data | Validation | Settings Tab | Allow: Whole number or Decimal. Then
add a message to the Error Alert tab
Regards
Trevor
> How do I format cell allowing only number entry and give message for
> retry?
> Thanks in advance for your help!
>
> ---
> Message posted from http://www.ExcelForum.com/
Kim-Anh Tran - 30 Apr 2004 23:22 GMT
And Have a good weekend!
Regards,
Kim-An
--
Message posted from http://www.ExcelForum.com