none
date errors in export to excel RRS feed

  • Question

  • When I export to excel using the export wizard the dates revert to US format. Project is set to UK fromat - Regional settings are to UK format. When I reimport to excell dates are invalid - Is there a quick workaround

    Thanks

    Richard

    Tuesday, September 27, 2011 9:10 AM

Answers

  • You could create custom number fields with formulas that reference the date fields you want.  These will export to Excel as numbers, and you can then apply Excel date formatting of any sort you like.
    Reid McTaggart Partner DeltaBahn LLC
    Tuesday, September 27, 2011 8:30 PM

All replies

  • Hi Richard,

    You can change the date format in EXL itself.


    Sapna S
    Tuesday, September 27, 2011 9:18 AM
    Moderator
  • Hi Sapna

    The problem is that project exports the date as a text field ie

    7/5/2007 8:00:00 AM and this will not convert in excel into a date format !

    Thanks all the same

     

    Richard

    Tuesday, September 27, 2011 3:33 PM
  • You could create custom number fields with formulas that reference the date fields you want.  These will export to Excel as numbers, and you can then apply Excel date formatting of any sort you like.
    Reid McTaggart Partner DeltaBahn LLC
    Tuesday, September 27, 2011 8:30 PM