Hello Community,
while running a Powershell Script from the Shell without any Errors, I get "Syntax Error" from PAD using the same Script.
The Script formats an Excel-Report and I need to set NumberFormatting in some Columns to "percentage".
I understand that this is somehow related to "https://powerusers.microsoft.com/t5/Power-Automate-Desktop/Power-Automate-Desktop-Unable-to-Render-URL-Syntax-error-invalid/td-p/850469", but for my purposes I require to pass this Line in my Script for Excel to understand the formatting:
$WorkSheet.columns.Item("B:D").NumberFormat = "0%"
But here's where PAD's confuses my command with its internal variables because of "%" and throws the Syntax-Error.
I would highly appreciate any help. Thanks!
