Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Import to Formatted Worksheet
Some Exporting Wizards will allow the choice of format during the process.
Assuming yours does not.........I frequently have to deal with "Excel files" that have been dumped down from a main Company computer. I just create a new Excel file and write a macro therein to retrieve the interim file, do all the re-formatting I want to, and then save it as the "real" file for my users.......... Vaya con Dios, Chuck, CABGx3 "tommcbrny" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
import formatted text | Excel Discussion (Misc queries) | |||
Across a worksheet, which cells I have formatted as locked? | Excel Worksheet Functions | |||
copy formatted (red font) cells from one worksheet to another | Excel Discussion (Misc queries) | |||
Create new formatted row in another worksheet | Excel Discussion (Misc queries) | |||
Converting 'General' formatted cells to Text formatted cell using. | Excel Worksheet Functions |