Checking code format is correct or not ?

Originally Posted by sktneer

Another way around....

Assuming that you have 100.000.01 in A1, then in B1 try this.....

=IF(FIND(".",A1)+FIND(".",SUBSTITUTE(A1,".","^",1))=12,"Correct Format","Incorrect Format")

I think to check length is necessary as user may add more numbers after second "." entry