In the right pane uncheck the Allow editing directly in cells option under Editing Options. Edit the M code in the formula bar to change the query to include a different currency and a different date. Script Lab Code editor.
Ill check it out today.
Then when you have Excel formulas in a given Notepad editor you can select Language XLF where the XLF will be below the Define your language option. Ill check it out today. These days F2 is often considered an old-fashioned way to edit formulas. I hope that Excel eventually includes a SPLIT function like the one available in Google Sheets.