Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Changing Date Format | Excel Discussion (Misc queries) | |||
Changing the date format | Excel Discussion (Misc queries) | |||
changing date format | New Users to Excel | |||
Changing to date format | Excel Discussion (Misc queries) | |||
Exporting Data to Excel-Date Format Changed | Excel Discussion (Misc queries) |