Restricting Cell Entry to "N12345678"

		Microsoft Office Forums > Microsoft Excel > Excel
Restricting Cell Entry to "N12345678"

FAQ

Thread Tools

Display Modes

11-27-2014, 12:46 PM

Pecoflyer

Windows 7 64bit Restricting Cell Entry to "N12345678"

Office 2010 64bit

Expert

Join Date: Nov 2011

Location: Brussels Belgium

Posts: 2,948

Pecoflyer has a reputation beyond repute

Perhaps

Code:

=AND(LEN(A2)=9,or((CODE(A2)=78,(code(a2)=110)),ISNUMBER(RIGHT(A2,8)*1)  )

To add rep click on the scale in the upper right corner of the post you want to rep.

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Selected cell is "copied" whenever I use scroll bar	CrabApple	Excel	5	09-07-2012 03:45 PM
'Linking' entered information to other "cells" from an original "cell" in MS Word	Wade	Word	6	09-03-2012 05:22 PM
Outlook 2003, Modify default "entry type" for new journal entries	narichardson	Outlook	5	03-14-2012 08:34 AM
How to choose a "List" for certain "Heading" from "Modify" tool?	Jamal NUMAN	Word	2	07-03-2011 03:11 AM
How can I paste cell "A1" contents to cell "B1" if cell "A1" is not blank?	Learner7	Excel	1	04-25-2011 04:39 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:01 PM.