Restricting Cell Entry to "N12345678"

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

FAQ

Thread Tools

Display Modes

11-27-2014, 10:03 AM

balbas662

Windows 7 64bit Restricting Cell Entry to "N12345678"

Office 2013

Novice

Join Date: Nov 2014

Posts: 2

Quote:

Originally Posted by Pecoflyer

Hi
in A2,try Data - Data Validation - Select " Custom" and enter following formula =AND(LEN(A2)=9,CODE(A2)=78,ISNUMBER(RIGHT(A2,8)*1) )

Adapt the cell to your needs

I'm not that great with Excel so this may be a noob question, but I wan the "N" to be constant but it can be lower case or upper case is that possible?

Thanks. Also I assume I hit the rep button to say thanks on this forum?

« 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 03:48 PM.