=IF(LEFT(T9,1)=":",DoYourFormula,"")

Vaya con Dios,
Chuck, CABGx3


"nastech" wrote in message
...
How do I skip a formula, if left of cell does not equal a colon, followed
by
7 numbers? thanks.

e.g.: date yymmdd
:060120

e.g.:
IF(LEFT(T9,7)= ??(:0000000),then do formula