Power Query formatting disappears after Close & Load in Excel

I formatted some columns as percentage and currency in Power Query, and it looked fine there, but after I clicked 'Close & Load,' all the percentage and currency formatting disappeared in Excel, even though 'Preserve cell formatting' is already checked. How do I fix this?