Cell Format will not show formmula result just the formula

I am placing a XLOOKUP formula in a workbook and all I get in the cell is the formula itself.  When copied down in the range the relative references also do not change.