making sure cell has j prefix

[stevesunfold]

hi guys i have a cell "h23" that must always start with a "j" or a "J"
the trouble is some of my users are only putting in the number
ie 2345 when it should be j2345 or J2345
is there anyway i can control this please?

[VBA Noob]

You could try a custom format

"J"#

or with code

Please Login or Register  to view this content.

VBA Noob

[Shijesh Kumar]

Select the cells which you want to start with J

Click on
Data --> Validation.

In Allow:
Select "Custom"


In Formula:
Type =LEFT(H23 , 1) = "J"

[stevesunfold]

brilliant thanks vba
the code is perfect
thanks aslso shijesh