Array constants can only contain text in double quotes, plain numbers (no currency symbols or percent signs), or Boolean values (TRUE and FALSE), separated by the comma and semicolon delimiters. They ...
To apply the dollar currency to a value, select the cell, press Ctrl+1 to launch the Format Cells dialog box, and select "Currency" or "Accounting" in the Number tab. Then, choose the dollar symbol ...
Account Number (Customer’s account number) Cheque Date – (Cheque issue date) Cheque Amount – (The amount should not be comma separated) Beneficiary Name – (Beneficiary of the cheque issued by account ...