Convert Account Code to Number formating

Hi Experts,

When I export the P&L report from XERO, I always get the Account Codes as TEXT, and everytime I have to mannually convert them into NUMBERS in order to do the mapping. I need to refresh 30+ tabs every month!!!

Please advise if there is anyway I can fix it as NUMBERS?

Thanks

Jerry

Hi Jerry

Welcome to the community forums! - depending on how you use DataDear you can achieve this by:

  1. Power Query on your data
  2. Adding additional columns at the end of the report with a formula to convert the text into numbers (such as =cell* 1]