Add CAST Operator in sql query so that the output goes to excel will treat as text instead of some special characters on scientific notation i.e e^1 like that

Add CAST Operator in sql query so that the output goes to excel will treat as text instead of some special characters on scientific notation i.e e^1

CAST(x.bank_account_num AS CHAR(28)) AS account_number