How to Save an Banner ePrint report as a “Text” document and convert to a Word or Excel document on your PC

Note: You can print the report from Adobe Acrobat® Reader; you do NOT have to download reports to Word in order to print

1. Downloading a report from Banner ePrint.

· After you select the report and pages you want to download, Right click the TEXT icon.

Selected Account Values

Cash Basis UNC Charlotte Repository BIXLER, C SYS DEV

About Banner ePrint

Help on Using the Validation Page | Logout

Cash Basis UNC Charlotte  : FBM092_ACT_MTD : Pick Pages : Account : Values

"1-11510"

"1-15135"

"1-15512"

· When you Right click on the Text Icon, a pop up box will display, and then choose “Save Target As…”

· The “Save As” dialog box will appear. Pick the location on your PC where you want to save the file. You can use the default filename, or key in your own. Then click on “Save”.

· The “Download Complete” dialog box will appear. Click “Close”.

2. Open the saved file in Microsoft Word.

· Open Word, locate the Text file in the folder where you saved the report, and then choose “Open”.

· The “File Conversion” dialog box will open and make sure the “Windows Default” option is checked, and then click “Ok”.

• Reformat the file in Microsoft Word.
  
  
• Select Edit from the toolbar pulldown menu
  • Choose Select All (Ctl+A) (this will highlight all text in the document)
    
    
• Select File from the toolbar pulldown menu.
  
  • Choose Page Setup
  • On the Margins tab change right and left margins to 1”; top and bottom margins to .5”; and Orientation to Landscape
  • Click “Ok” button.
    

o Select Format from the toolbar pulldown menu.

§ Choose Font

§ Font = Courier New

§ Style = Regular

§ Size = 8

§ Click “Ok” button.

o Click anywhere in the document to un-highlight the text.

§ Select File

§ Choose Save As

§ Change “Save As Type” to “Word Document”

§ Click “Save” to save the re-formatted version to your PC.

3. Open the file in Microsoft Excel.

· Open Excel, locate the Text file in the folder where you saved the report (be sure to change the “Files of Type“ to “All Files”), and then choose “Open”.

· The Text Import Wizard dialog box will open.

o Follow the Text Import Wizard through the 3 steps and click “Finish”.

· Save file as an Excel file.

o Select File

o Choose Save As

o Change the File Name if desired.

o Change “Save As Type” to “Microsoft Excel Workbook”

o Click “Save” to save the re-formatted version to your PC.

Back to Banner ePrint Home

Questions or Problems related to Banner ePrint:

Email the Banner ePrint System Administrator at eprintadm@email.uncc.edu