Forum Discussion

Cathy1's avatar
Cathy1
Contributing Cover User
3 years ago

exporting item pricing

Hi I want to export an item sales list to excel to 3 decimal places.  Every time I try to do the export it rounded up to 2 decimal places when it imports to excel from MYOB.  Am I doing something wr...
ChrisMYOB's avatar
ChrisMYOB
Former Staff
3 years ago

Hello Cathy1 

 

Thank you for your question.

 

It is possible that your excel settings have it automatically round to 2 decimal places which is why when you import it, it is automatically changing to the 2 decimal places rather than keeping the 3 when you have exported the file. 

 

The easiest way in Excel to change a decimal amount is on the Home tab, click Increase Decimal or Decrease Decimal to show more or fewer digits after the decimal point.

 

I would suggest changing this and then importing the data to see if this works. 

Please let me know how you go.

Mike_James's avatar
Mike_James
Ultimate Cover User
3 years ago

Hi Cathy1 , ChrisMYOB , this is a long-standing issue, but I can't find any trace in my own records or in the community of it being raised previously.

 

PS: I just found it mentioned in my email to one of the MYOB inventory team in August 2021.  

Looking for something else?

Search the Community Forum for answers or find your topic and get the conversation started!

Community home

Level up your skills using MYOB software.

 

Find help guides and technical solutions for all MYOB products here

Explore video tutorials for our software at the MYOB Academy here

 

Dig into MYOB Academy for free courses, learning paths and live events to help build your business with MYOB.