Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi David, the output isn't a file, just a screen output of a SAP (the
"famous" ERP) execute command, then you have the "Save as Excel" menu button, but the problem is that it works very well with Excel97 and very bad with Excel 2003/2007, and I'm disconcert by this behaviour: I don't want to reinstall Excel 97 to everybody and I'd like to avoid the futher step of saving as CSV file and reopen into Excel2007!!!! Thank you "David Biddulph" wrote: You haven't said in what form your report has produced the data. If it is a CSV, you can either rename the CSV as .TXT, or use Data/ Import External Data, rather than just opening the CSV. That way, you'll be able to specify the format of the columns on the import. Specify as text, rather than General. -- David Biddulph |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Disable automatic GETPIVOT | Setting up and Configuration of Excel | |||
Disable automatic GETPIVOT | Excel Worksheet Functions | |||
Automatic CSV Data Conversion | Setting up and Configuration of Excel | |||
Disable Scientific Notation conversion | Excel Worksheet Functions | |||
Disable automatic date conversion feature | Excel Worksheet Functions |