Hi,
Can anyone let me know as I have a column with multiple codes; whereas I have to apply formula only on cell with 6 digits number. Kindly share the formula.
Kindly share sample file... As we can't (always) guess what the data looks like, let alone offer a working formula.
Given the test is on cell A2 an test is length being 6 digit and it needs to be a number.... Perhaps this can work :
=IF(AND(LEN(A2)=6 , ISNUMBER(A2+0)) , your formula , "")