OK, did a search and found this is a known bug.
The suggested workaround is to save the report as a .csv, and open in a spreadsheet program. Fine. The problem is that all of the units are lost, so we don't know if it's teaspoons, ounces, pounds, etc.