[Powerschool] Exel Question

[Wayne Wiens]

Elaine,

Open a new Excel doc.
Goto the Data menu and select Import Text File from Get External Data.
Browse to your file and select it.
Click Next on the first page.
Select Comma delimited.
Click Next
Highlight all the columns in the display at the bottom of this window  
(Scroll clear to the right to get to the far right column, hold down  
the shift key and click on the far right column. All the columns  
should be dark.)
Click on the Text radio button at the top of this window.
Click on Finish.
Click OK to insert in this new document.

This should keep your data in the form you need.

Good luck.

Wayne Wiens
Technology Director
Adams Central School District
402.463.3285  x315



On Sep 21, 2007, at 10:58 AM, Elaine Grasz wrote:

> I need to know how to keep Excel from changing the format on cells  
> when opening the NSSRS reports from PowerSchool.  I used to know  
> how to do this but can’t figure out how to do it now.
>
> Thanks for your help.
>
> Elaine Grasz
>
> Technology Coordinator
>
> Brady Public School
>
> PO Box 68
>
> 112 E Popleton
>
> Brady NE  69123
>
> 308-584-3317  x 201
>
> egrasz at esu16.org
>
>
>
> _______________________________________________
> Powerschool mailing list
> Powerschool at lists.esu10.org
> http://lists.esu10.org/mailman/listinfo/powerschool
>
> -- 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.esu10.org/pipermail/powerschool/attachments/20070921/fff93094/attachment.htm