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.

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

__________________
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

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?

Perhaps 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