clearing empty cells in export files

Hi wondering if anyone else has noticed this problem? I do a lot of csv and xls exports, and lately empty cells are not actually empty.

For example, I export all of my bank transactions for January. There are columns for Debits and Credits. No row will have data in both of those fields.

If I try to write a formula the result always comes back as an error.
I found that going to each empty cell and pressing the delete key fixes the problem.

But that's really not a practical solution - is there a setting in the latest version of Excel that creates this issue? I've been exporting and working in Excel since the late 90s, and this is a relatively new thing.

Thanks!

I'm exporting data from a website into Excel. This comes up whether I do it as a csv or xls.

I've uploaded the workbook that exported today's data. The first section is as exported, came back with an error when I tried to calculate a number.
The second section is after pressing Delete in the empty cells, and the formula works correctly.

My question is, why do I have to select the empty cells and Delete? What changed since the earlier Excel?
Most importantly - How do I stop this from happening? Going through a month's worth of data and pressing the Delete key is not a practical solution.

Ya this is a legit problem that i don't have a fix for. What i do have is a simple quality of life fix potentially.
1. Select Columns D and E
2. Change format to Number
3. With columns D and E selected select "Go to Special" on the home ribbon.
4. check the "Constants" box and uncheck Numbers Logicals and Errors. (So only Text will be selected and Constants.) Hit ok
5. Hit the Delete button on your keyboard.

This will fix all the effected cells and make your formulas work. Make sure to retype your column D and E headers "Debit and Credit"

Thank you! That will save me so many keystrokes

Why does MS have to make things so convoluted ...?