title: iif (Iserror ()) function still returning #error
body: <p>I have the following function that creates a column in my query: </p>
  
  <p>MTD: IIf(IsError(FormatNumber([62xx]![F40])),0,FormatNumber([62xx]![F40]))</p>
  
  <p>This is linked to an Excel file and where people put numbers and text in the same column (F40 in this example).  I need to know if the thing I am looking at is a number or text.  If it's text I want a zero, if it is a number I want the number.  I know that when I use FormatNumber([C107_62xx]![F40]) on a text line I get an error.  I would assume when I get an error, then my iif formula above would convert that to a zero and the world would rejoice.  For some reason I am still getting a #error even with my iif statement.  What am I doing wrong?</p>
  
  <p>I have also tried using the IsNumeric function but I still get #NUM! errors that come through.  </p>