Data Validation

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Sumit - 21 Dec 2005 15:23 GMT

Hi,

How can i define the condition so that a user can enter the data in
only the following format:

AAAAA1111A, where "A" Represents any character & "1" represents any
number.

Sumit

Reply to this Message

Gord Dibben - 21 Dec 2005 20:54 GMT

Sumit

See this search result from google.

Validation is for Canadian Postal Code format. You should be able to adapt.

http://snipurl.com/kz3j

Gord Dibben Excel MVP

>Hi,
>
[quoted text clipped - 5 lines]
>
>Sumit

Reply to this Message