formula ignoring zero's

  1. G

    Dropping Zeros, But In A Formula?

    Hello Everyone, I know from time to time we have all dealt with excel issues involving the program dropping leading zeros, but this case is a first for me. In order to monitor account numbers in a spreadsheet, I would like to setup a formula as follows: =IF(OR(A1=TR002,A1=TR050),"Yes","No"))...
  2. N

    If Formula Is ignoring the zero's

    Please help as the Formula is working on the rest of the sheet but not this one section... =VLOOKUP(H13,'Master Sheet'!$H$2:$W$1546,10,FALSE) <TABLE style="WIDTH: 189pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=252 border=0 x:str><COLGROUP><COL style="WIDTH: 64pt...

Some videos you may like

This Week's Hot Topics