i require a formula for custom data validation to permit entry 5 digit numeric characters only.
No spaces, or alpha permitted.
Note that the cell format will be text, to enable leading zeros to be entered & displayed (as permitted)
Thanks.
refer previous post for similar for aplha only.
http://www.excelforum.com/excel-work...ml#post2007297
I was unable to adapt for my new requirement.
Any help would be appreciated
Bookmarks