Excel: Data Validation Must Contains mark ' (approstrops) in Left

hi all, i need your help how create data validation with criteria : - start mark ' (approstrops) in left position like example this below : '6136716 '981289 '2091234 etc... i have using formula =LEFT(B3)="'", but still not working... any help me, thanks in advance... m.susanto

This question generated 13 answers. To proceed to the answers, click here.

This thread is current as of October 02, 2014.

For more resources for Microsoft Excel