How can i force the user to enter in cell (a1): then two characters and (-) and 3 zeros and one number? .As follows:
(FY-0008)
and wrong message.
How can i force the user to enter in cell (a1): then two characters and (-) and 3 zeros and one number? .As follows:
(FY-0008)
and wrong message.
1. Choose Data Validation
2. Select custom option
3. Paste following formula
And you will be able to control it!!!=AND(LEFT(A1,3)="FY-",MID(A1,4,3)="000",ISNUMBER(ABS(RIGHT(A1,1))))
Regards,
--------------------------------------------------------------------------------------------------------
Shrivallabha
--------------------------------------------------------------------------------------------------------
Using Excel 2016 in Home / 2010 in Office
--------------------------------------------------------------------------------------------------------
Perhaps:-
If Not Left([a1], 6) Like "[A-Za-z][A-Za-z][\-][0][0][0]" Then MsgBox "Please Enter first 6 characteres like Data ""Az-000""" Else MsgBox "Format OK" End If
thank U verey much Shrivallabha Great idea of your solution
..
MickG I am grateful to you