How to Display GL Accounts without Chart of Account Prefix

Hello,

I have a BW Query that has accounts in row axis. But it gets displayed with Chart of Accounts as a prefix in the excel workbook. How do I remove the prefix? In the example below, C001 is chart of accounts, 6010 is the account number. Thanks