How Excel interprets exported dates from TAS Books 2?

  • Thread starter Thread starter GillyB
  • Start date Start date
G

GillyB

Has anyone come across a problem with date formatting
when dates are exported from TAS Books 2 accoutning
software to an Excel workbook? For eaxmple in TAS Books 2
the date is 04/06/2004 but when exported to Excel it will
appear as 06/04/2004. Does anyone know the solution to
this problem?
Thanks
 
It/s a format problem. compare in Europe's date format to
america's. you probable have the american version of
excel.
if it is a problem for you, you can create a custom date
format. goto edit>cells>custom. in the type box enter
dd/mm/yy(or what format you want to see). by default I
guess you are set up as american date format so you may
have to reformat the date after import. I don't know how
you are importing. if you are using a macro you can add
the refomat to it.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Date Format changing when exporting from another app 1
Dates don't appear properly after downloading data from Accounting 4
Changing how Excel INTERPRETS dates 1
Date format getting muddled 3
Excel not recognizing dates as dates 1
Default Dates 1
Date glitch? First 12 days of month format differently than the r 3
how do I export excel spreedsheet to outlook address book? 2

Back
Top