Hi @MMDDW ,
You can do this with a quick Office Script and Power Automate flow. I will give you an example here and the TypeScript to copy and paste in.
The first thing you want to do is open up your Excel workbook in a browser because that is the only place you and add an Office Script (as of August 2023).
Click on the Automate tab and then New Script.
Here's your TypeScript to cope/paste.
function main(workbook: ExcelScript.Workbook) {
let selectedSheet = workbook.getActiveWorksheet();
selectedSheet.getRange("T:T").setNumberFormat("MM/dd/yyyy");
}
Replace the default code with yours above.
Save, Close.
Back to Power Automate.
Here you have a simple trigger button and one action.
Save and Run. Results are below.
This is a great option especially if you have thousands of rows and need a quick solution.
