When Microsoft Excel opens a .csv file it assumes it knows what type of data is in every column. If there are numbers it must be a number. If there is some text, it must be a text column. If Excel decides a column is a number it will drop all the zero's at the beginning assuming they don't matter. This makes UPC data incorrect.
![Excel No Leading Zero](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjnqkvAUhstFoXpgdyHIiFDt-b6fyFFyfZlEb8COspZVAxRCgcI1j7x4w3gA5xho40EVki42xgvoMOlq7wXARLI6lxGdXIPwod0RbxAlA9Kl0rZbwEYVMPpdL53YYtPxCn7InanF8Ef7NiC/s400/no-leading-zero-excel.png)
1. Download The Price Guide
Download the price guide and save it to your computer. (If you're not a subscriber you can start a free account)2. Change the Guide to a Text File
Go to the folder where you saved the price guide. Right click the file and choose Open With > Notepad.
![Open File in Notepad](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiieL37PuFBOKwDpLvq-YmZJ-z-cbvYTPW9O9Rjos9sGE3clkJVK-iYRLDtqlvJifgbfozS5CaolOtjYGC6pqxX08Ot7BJIAeTAS10VwyePnPKIHdLamRYJLyCS_6Xrr1zm7qI4qJK60mFo/s400/open-file-with-notepad.png)
In Notepad, go to File > Save As. Save the file a .TXT file type.
![Save As](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhH3mWX3TNww-myFQ_siSglYGW3xjHzGKnUfqgkVP_VKGBeZmXxC5D6UIxt_YqaWC0swbB2aJCOLlkF3rmBTnwqZn5_5SvGBdV5Y0fndfFeoGSTAIiZ6A_OmejXX3xIAwTWhsk647_sFft2/s400/save-as.png)
Open The .TXT File in Excel
Open Excel and open the file "today.txt" that you just created. This will open a series of three questions.Question 1: Select "Delimited" and then click "Next"
![Excel Text Import Wizard](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEihn1s3yZxs7lfcvhCU3I0SAh8U1ofIlc6FPC8xkaZEhs5_OFhAUJeq60WoY6AWlor9xllTOzNeLvRlTWJGHjMLARUlZZ0Ek_c_SOQ7af45tQjW1NrYTLeMvxa4atdLflzUJ8YkpJeUDOX1/s400/text-import-wizard.png)
Question 2: Select "Comma" and click "Next"
![Excel Text Import Wizard 2](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhQnseRUcjV5L75QpCGkWtMlsSQuNPOe4MZ_9nPp5zjDynvdf3Mmguen586mTHWxPpA3fPTxQFhKw_n0DMYVHtrb2htseLcDEL3CvhhZNBs12iPoopDukNkIP1EYZVeqG-g9o-AxkCk3YP6/s400/text-import-wizard2.png)
Question 3: Find the UPC column and change it to "Text" instead of "General". Click "Finish"
![Excel Text Import Wizard3](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh5vibsBmy2BANK7nNycxxRrPhX3nF86MHNIWViAyoehVKc4n16AM_OG3amnBJFdHhyphenhyphen-apedRhYk4raaZcDqLyhkniKDdkYMVQT8_DyXfJs16xO3-Hq5djWHnYuICZfkKxljjAM_3ttonxD/s400/text-import-wizard3.png)
Spreadsheet Showing Leading Zero in UPC
Excel will now show the price guide with the leading zero still intact so all UPC data will be the complete 12 characters.![Excel Showing Leading Zero](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg2oMQNeMqU5upka-BufDiFG5WOLdX4FKtinxfWQqRKQRMjyUvw-e1-B_PgLjnlFOc1PKFgb1rPJwFmI0vcn_UnmOqSiVB-kmGqOcMSzqefp-aDqoSSDUc0FHxrw8Ah_01K-JKDFul-aaM9/s400/leading-zero-in-excel.png)
This article is a part of a series of posts with how to articles for our price guide subscribers.
0 comments :
Post a Comment