This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
@stevegeorge In order to keep the formatting that you would like in excel, I would recommend formatting the excel file that way, and writing out to a named range in that file. This will keep the formatting and update the values. To write out to a named range, write the name of the range where the sheet name is usually written (after the |||). Be sure to select "Overwrite Sheet" as well.
If this does not give you your desired result, try downloading the Legacy Excel Driver and write to the same output file and range.