I'm trying to use the data validation to make sure people use the same format when entering product codes into a s/sheet.

The product codes are 5 numeric digits teh letter 'v' then one or more numeric digits again.
eg
12345v1
12345v12
16549v3

Is there a way to use custom validation to make sure that the text entered follows this convention?

Thanks for any help you can offer.