Share your ideas for improving the new AccountRight. Vote on ideas and discuss them with the MYOB product development team.

AccountRight

Export to Excel: Remove leading characters

Contributing Cover User

17Posts

0Kudos

0Solutions

17 Posts
Contributing Cover User
Australia

When you export from AccountRight Plus 2016.3, to an Excel file (.xlsx) the GL account values appear with an extra character on the end.  It's ANSI 13.  This is really annoying for any formulas or macros that use the GL account values.

This problem doesn't occur when exporting to .csv files.

Do you think you could "clean" this up.  I put clean in quotes as Excel's Clean() function fixes the problem.

 

"Get rid of the non-printing character (ANSI 13) from GL accounts when exporting to Excel"

Current Status: Done
Last Changed: August 2018

Hi Everyone

With the release of AccountRight 2017.2 the account number and name indentation on reports sent to Excel have been removed.

 

You can find out more information about this and other changes, including information on obtaining AccountRight 2017.2 from AccountRight 2017.2 now available

3 Comments
MYOB Moderator Steven_M
32,771 Posts
MYOB Moderator

Hi Everyone

With the release of AccountRight 2017.2 the account number and name indentation on reports sent to Excel have been removed.

 

You can find out more information about this and other changes, including information on obtaining AccountRight 2017.2 from AccountRight 2017.2 now available

Contributing Cover User oxfam
17 Posts
Contributing Cover User

Does this also apply to AccountRight 2018.2 too, or just 2017.2?

MYOB Moderator Steven_M
32,771 Posts
MYOB Moderator

Hi @oxfam

 

The change was introduced with the AccountRight 2017.2 range and has carried across to the AccountRight 2018.2 product.