Hi there,
Have done a few searches on this, but haven’t found a method yet that works for me.
I would like to set the Cell Format of a column in Excel to Text or Numbers or General.
I have tried using the script below, but I get an error that the Applescript event handler has failed.
tell application "Microsoft Excel"
set number format of (cells of (sheet "Sheet1" of active workbook)) to "general"
end tell
I’m using Excel v14.3.9 (2011) on OS High Sierra
Any ideas?