Date Format changing when exporting from another app
 

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

Date Format changing when exporting from another app
 

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.

"BP" wrote:

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