Forum Discussion

EEAD's avatar
EEAD
Experienced Cover User
4 years ago

Report Exporting to Excel (want to change white background!)

Using MYOB AccountRight Premier.

 

When exporting report to excel, I am facing the following issues and want to change them.

Please advise how to achieve these?

 

1. White background

 

    Exported excel shows white back ground. This looks nice but difficult to see line items witout any cell lines.

    I guess many accountants feel same but how to change this? I tried cell formatting but could not change them.

 

2. Text rather than numbers

 

   All cell informaiton was exported as text even only number cells.

   Most annoying thing is negative numbers are exported as #### cr rather than simple negative numbers.

   This makes difficult to manage to alter and edit as reports.

   Any solutions?

 

Thanks for your help in advance!

  • Hi EEAD , what version of Premier are you using? And what report are you running?

     

    Version 19 created Excel output for the GL Summary report with negatives as "1234.56cr", but I think AccountRight lIve does this correctly. 

  • EEAD's avatar
    EEAD
    Experienced Cover User

    Using MYOB AccountRight Premier.

     

    When exporting report to excel, I am facing the following issue and want to change them.

    Please share your idea?

     

    Text rather than numbers

     

       All cell informaiton was exported as text even only number cells.

       Most annoying thing is negative numbers are exported as #### cr rather than simple negative numbers.

       This makes difficult to manage to alter and edit as reports.

       Any solutions?

     

    Thanks for your help in advance!

  • Mike_James's avatar
    Mike_James
    Ultimate Partner

    Hi EEAD , what version of Premier are you using? And what report are you running?

     

    Version 19 created Excel output for the GL Summary report with negatives as "1234.56cr", but I think AccountRight lIve does this correctly. 

    • EEAD's avatar
      EEAD
      Experienced Cover User

      Hi Mike_James ,

       

      As you noted, I know the AccountRight lIve (v2021) can display it as negative numbers.

      Since I have a couple of company file which cannot go online due to our licence, I just wanted to know any other way, but thank you!

       

      I am sitll looking to change the background from white to none, so if you know any solution, your input is highly appreciated.

      • Mike_James's avatar
        Mike_James
        Ultimate Partner

        Hi EEAD , you originally said that you wanted the cell borders back. This is an Excel setting under File, Options, Advanced, Display Options for this worksheet, and tick the option to show gridlines. You can edit the source template as before, and change then save it. You will get gridlines across all the transaction rows. 

         

        Note: Be careful to close your edited template before sending any MYOB report to Excel, or your report will appear in the actual template!

         

        I use an Excel macro to help with changing numeric cells containing "cr" to negative numbers.