View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
tommcbrny tommcbrny is offline
external usenet poster
 
Posts: 57
Default Import to Formatted Worksheet

I work with a system that can export information to Excel, but I need to
change the format of two fields each time. Currently, dates export in format:
mm/dd/yyyy hh:mm
and work estimates export in format seconds (ex: 2 days or 16 hours is
exported as 57600).

Can I create a worksheet or template in excel with my desired format and
then import or copy / paste the exported data to it?

NOTE: The system is also capable of exporting to XML.

Thank you,

Tom