Okay, this is a dumb one. When highlighting any cell it only shows the last two characters in the formula field.
Can't seem to find a permanent fix yet, but it seems to happen only when using two monitors. The workaround is to view Excel in the primary monitor and the formula field then shows all the cell's contents.
And from my searches, this seems to have been happening since Excel 97...good stuff.