Date Format changing when exporting from another app

B

BP

Hi All,
Hoping someone can help. I use a Financial loan application called Tvalue. T
Value includes a feature to export data to excel. Tvalue uses the same date
format as my OS settings, so in AUS is dd/mm/yyyy.

When you export data from Tvalue to excel, the date changes to mm/dd/yyyy
but you cannot change the format back in excel because it seems to be
importing values. So in long format, when Tvalue sees the date as
01-jun-2008, excel imports this as 06-January-2008.

Does anyone know if this might be an excel issue.

Thanks,
Brett
 
J

Joel

Everybody seems to having an issue with saving dates. I write my own macros
to save data to text files (either .txt or .csv). If you want to use the
macro approach let me know and I will help.
 

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

VBA - exporting serial letters to single documents 0
Date Formats 4
Publisher is filling blank lines with data 2
Date Format 10
Export Report with Graph to Excel error 2495 1
Excel date formate doesn't change 0
Incorrect date value when open DBF file in Excel 0
Date and years calculation 2

Top