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?
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?
Last edited by stevesunfold; 11-23-2008 at 06:06 AM.
You could try a custom format
or with code"J"#
VBA NoobPlease Login or Register to view this content.
_________________________________________
Credo Elvem ipsum etian vivere
_________________________________________
A message for cross posters
Please remember to wrap code.
Forum Rules
Please add to your signature if you found this link helpful. Excel links !!!
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"
Shijesh Kumar
http://shijesh.wordpress.com/
brilliant thanks vba
the code is perfect
thanks aslso shijesh
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks