Restricting Cell Entry to "N12345678"

[balbas662]

Hi,

I am trying to restrict certain cells to have to start with "N" followed by 8 digits.

For example N12345678

The N has to remain constant but the 8 numbers can change as entered by the user.

Any help will be apprceciated. Thank you for your time in advance.

[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

[balbas662]

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?

[Pecoflyer]

Perhaps

=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.