title: Excel PowerQuery: null values in a number column
body: <p>I am using a PowerQuery query to import data from CSV files. Some cells in the CSV files are empty. When imported into PowerQuery, these cells get an error "Cannot convert the value null to type Number." The field gets (correctly) identified as type=number. However, I'd really just like these error values to just be blank entries, like they were in the original file. "Replace Errors" only allows me to change these error values into numbers (it won't let assign a blank or any non-numeric value). Any ideas on how to get these values to just be blank (or Null)?</p>