MYOBCommunity
Partner Zone
|
|
Partner Zone

Exporting to excel - date formatting changes!

Clarkin
2 Posts
Cover User
Australia
Clarkin
Cover User

2Posts

0Kudos

0Solutions

Exporting to excel - date formatting changes!

When we export Employee Card File information to excel, some dates are changing. For example - a D.O.B. might be 01/11/2000 (01 November 2000), however, it comes through to excel as 11/01/2000 (11 January 2000). Same thing occurs for Start Date. Really annoying to have to manually check each one off, and change as required. The specific report is Reports / Payroll / Employees / Employment Details.

 

I've checked our Computer settings and the Region & Language tab says Format = English (Australia), Location tab says Current location = Australia. We are in Perth, WA.

 

Would really appreciate a solution. Thanks.

1 REPLY
MYOB Moderator Steven_M
25,038 Posts
MYOB Moderator
New Zealand
Steven_M
MYOB Moderator

25038Posts

2871Kudos

3648Solutions

Re: Exporting to excel - date formatting changes!

Hi @Clarkin

 

When you send data to Excel, the formatting of the cells can be slightly changed, this is due to the way Excel does interpret the data.


If the data is not being formatting as you are after you can look at:

  • (If on AccountRight Classic v19) - Send To >>HTML or Tab-Delimited Text File or Comma-Separated Text File.What this will produce the corresponding file, which can be then be opened in Excel (would need to select to open all files) to display the data. 
  • (If on AccountRight 2017) - Export the required data out using the File>>Import/Export Assistant. This will generate a text file to which you can open in Excel. Alternatively, configure the Card Lists window show the required information and copying that information to the Clipboard, which you can then paste into Excel or similar product.

Kind Regards,
Steven
MYOB Client Support
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