Hi,
I want to apply Data Validation to 11 digits (numbers) in a merged cell (F4:M4).
I have tried Data Validation>Text Length>Equal To> =AND(ISNUMBER(F$4),LEN(F$4)=11) but it does not work.
Also tried using Data Validation>Custom & then same formula, does not work.
There should be 11 digits starting with 0 & all should be numbers.
Please help.
Bookmarks