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

format date 5
Date format changes in mail merge using Excel worksheet as data 2
date format problem 1
Date and years calculation 2
Excel 2002: How to make the date format uniform ? 1
Date automatically swaps 6
Change of date format when syncing Excel 2007 to Excel Mobilw 8
Losing date format when saving .csv files 10

Top