Excel Tips and Tricks
Create a Copy of a .CSV or a .DAT File
How do I create a copy of a .CSV or a .Dat file? Step 1. Locate File Locate the .csv or .dat file you want to copy (normally in Documents or on the Desktop) Step 2. Select File Right click on the Selected file Select the Copy menu option Step 3. ...
Adding a leading zero to a number in excel
Adding a Leading Zero in Excel Excel is used to modify documents so they can be imported into Stockbook. Excel may delete the leading 0 on IDs but they must remain present e.g. the ID number 091234 will appear as 91234 when ...
How to use the find and replace function in excel
Using the find & replace function in Excel Before importing Excel files into Stockbook you may need to find and alter some of the data. For Example: The data file has “Ewe” and “Ram” instead of “Female” and “Male” Before making any alterations to ...
Excel is cutting off numbers from Id.
Excel is Cutting off Numbers from ID After Exporting data, Excel is cutting off Numbers from ID's. Step 1. Open a New Excel File Select Data tab Select From Text Select the file that has data in it Step 2. Choose File Type ...
How to Save an Excel File as a CSV File
How to Save an Excel File as a CSV File Note: Always create a copy of a .csv file before opening to avoid loss of data If you are importing data from excel into Stockbook the file must be in a Comma Delimited file otherwise known as a .csv file. ...
Duplicate values in Excel
Duplicate values in Excel Finding and highlighting duplicates in an Excel spreadsheet column An example of when you may wish to find duplicates in Excel is to confirm that there has not been any human error when inputting data into Excel Step ...