AccountRight

Exporting to Excel - Remove account number indentations

Montagu
Cover User

3Posts

4Kudos

0Solutions

3 Posts
Cover User
Australia

We recently upgraded to live version, 2016.  In previous version 19 we were able to send reports with account codes to Excel without "indentations" and existing vertical lookup formulas worked well.  NOw, however, it sends them with "indentations" which are unable to be got rid of easily.  I feel that reports being sent to Excel should go with very little formatting, and certainly not these "indentations".  I am awre that formulas can be written to remove them, but we shouldn't have to go to that trouble when it worked perfectly well with the old version. (see attached screen shots).

 

"Accounts codes transferring to Excel"

Capture2 2016.2.PNG
Capture2 2016.2.PNG

Current Status: Implemented

Last Changed: November

Hi Everyone

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

Attachment.PNG

 

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

4 Comments
Partner ASWatCR
238 Posts
Partner
ASWatCR
Partner

238Posts

442Kudos

0Solutions

Agree and have voted

Experienced Cover User RoebuckMS
16 Posts
Experienced Cover User
RoebuckMS
Experienced Cover User

16Posts

1Kudos

0Solutions

What are the formula's to remove the indentation?  I am aware of =Trim(A1) etc.  But is there another?

MYOB Moderator Steven_M
22,961 Posts
MYOB Moderator
Steven_M
MYOB Moderator

22961Posts

2608Kudos

3276Solutions

Hi Everyone

We are in development of a way in which to remove those account indentations from Excel spreadsheets templates used with AccountRight.

MYOB Moderator Steven_M
22,961 Posts
MYOB Moderator
Steven_M
MYOB Moderator

22961Posts

2608Kudos

3276Solutions

Hi Everyone

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

Attachment.PNG

 

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