Partner Zone

% sign changed to $ when exported to excel

Toni5
Contributing User
5 Posts
Contributing User
Contributing User

5Posts

0Kudos

0Solutions

% sign changed to $ when exported to excel

Hi. When I exported aged payable report to excel, the % sign is changed to $ sign.  What setting do I need to into to correct this?  Hope someone can help me.

2 REPLIES 2
Mike_James
Ultimate Partner
4,965 Posts
Ultimate Partner
New Zealand
Ultimate Partner

4,965Posts

2,230Kudos

651Solutions

Re: % sign changed to $ when exported to excel

Hi @Toni5 , this is a limitation of the Excel template, which can only have one format set for the whole of the data rows. You will need to reformat that last row manually.


Regards, Mike (mike@datawise.co.nz)
DataWise Limited (www.datawise.co.nz), developers of:
DataWise Report Writer - Custom Reporting from MYOB programs
(Including AccountRight Classic/Live, and exo Payroll)

Toni5
Contributing User
5 Posts
Contributing User
Contributing User

5Posts

0Kudos

0Solutions

Re: % sign changed to $ when exported to excel

Hi @Mike_James,

 

Thanks for response.  Much appreciated.  

Didn't find your answer here?

Try using advanced search to find a post more easily Advanced Search
or
Get the conversation started and make a new post Start a Post