When I download to excel in NAMSR or NAMSR Plus, some of the Work Unit Codes show up as scientific notation. How can I fix this situation?
• Run a Query which contains Work Unit Code as a result • Click on the word “Download” in the upper corner of the query panel • Click on the option to Save • Choose a destination for the file • Rename the file, and change the extension of the file to .txt. For example, Document1.txt • Open Microsoft Excel • Click on File, Open. Change the Files of Type to read “All Files.” Open the file that you just saved. For example, Document1.txt • Use the text import wizard in MS Excel to open the file • Make sure that Delimited is the box that is checked. Hit next • Click on comma. Hit next • Click on the column with the Work Unit Code and switch the column from General to Text • Click Finish The file should now show all the Work Unit Codes in text format, which will fix the Scientific Notation problem. 10. How do I copy data into another application? Once your query has been completed, right-click on the edge of the table and select Copy as text. Then paste (Ctrl-V) the results into any other ap
