Power Query showing Null but values exist?

I have a power query that is showing "null" but the excel table it is pulling from has numbers in it. I have 8 other sheets in the workbook that have the same table with the same formula and those return numbers just fine. The numbers are in a "general format". I've copied formatting, I've reloaded the query. When I go into the applied steps then the table turns to Null when I expand the data from the table. Before then I can click on Table and preview the results and the numbers show just fine. If I delete those steps and recreate it, it still shows Null.