Thread: A validation rule on Alpha and Numeric characters
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sar* Sar* is offline
external usenet poster
  
Posts: 1
Default A validation rule on Alpha and Numeric characters
Hey,

I want to create a validation that when i enter a mixed numeric and alpha
reference that i can prevent changing its format.

For example:

Everytime i enter my "number" FEE1234, that the cell keeps the formatting
"@@@####" and prevents me using any other format indicating n error message.

Cheers!
Thanx in advance
Sar*

Reply With QuoteReply With Quote