Here is the problem. When the format of a column in the original Excel source includes two decimal points, the cell only contains cents (ex .40), and the datatype is changed to Currency in Power Query, the data loaded back into Excel is .4 not displaying the 0 after the .4. If data changes are frequent, this puts the burden on the user to continually reset the formatting in Excel.

Besides using VBA Macros, is there a way to ensure the format of the data in the transformed Excel Sheet does not get altered by Power Query on every refresh?