View Single Post
  #1   Report Post  
Nick B
 
Posts: n/a
Default Exporting Data to Excel-Date Format Changed

When exporting large amounts of information into Excel (Office 2000) some of
the date formats are changed but not all.Most are kept as DDMMYY but some are
turned around like US format into MMDDYY.Before exporting it will read
11/4/05 but after exporting into excel becomes 4/11/05.As i say 80% of dates
remain the same as from Citrix program they been exported from.Any ideas
anyone?