• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar

Support Your Tech

Instructions and tutorials to help you get the most from your applications and devices

  • Android
  • Excel
  • Word
  • iPhone
  • Mac
  • Docs
  • Slides
  • Sheets
  • Streaming
You are here: Home / Excel / How to Show Excel UPC Numbers in Full

How to Show Excel UPC Numbers in Full

May 18, 2020 By Matt Jacobs

The steps in this article are going to show you how to display Excel UPC numbers in full, as opposed to the scientific notation that it displays by default.

  • This setting will only apply to each worksheet for which you make this formatting change. It doesn’t carry over to other spreadsheets or new spreadsheets that you create.
  • This formatting change that we are making is incredibly useful for making your information display properly in Excel. There are options for currency, text, and you can create custom values if you want to display leading zeroes in numbers as well.
  • This guide assumes that the UPC numbers you want to show in full start with a number other than zero. If they do start with a zero, then you will need to choose the “Custom” option, then enter a number of zeroes in the “Type” field equal to the number of zeroes in the UPC number.

Storing product information in Microsoft Excel typically involves things like product names, prices, and inventory.

But it can often include UPC numbers as well. However, you have probably found that Excel tends to display these numbers in a format like 1.23456E+11, which can be problematic if you need to view those numbers frequently, or print them out.

Fortunately this is a problem that you can fix, as it is related to a simple formatting issue.

Our tutorial below will show you how to select and format a range of cells in Microsoft Excel so that you can display Excel UPC numbers so that all of their digits are visible.

The steps in this guide were performed in Microsoft Excel for Office 365, but will work in most other versions of Excel as well.

How to Show Excel UPC Numbers in Full

Step 1: Open the file in Excel.

Step 2: Select the cells containing the UPC numbers.

select the cells containing UPC numbers

Step 3: Right-click on a selected cell, then choose Format Cells.

choose the Format Cells option

Step 4: Click the Number option in the left column, change the Decimal places value to “0”, then click the OK button.

Excel UPC number formatting

You can select an entire row by clicking the row number at the left side of the spreadsheet, or you can select an entire column by clicking the column letter at the top of the spreadsheet.

You can select the entire spreadsheet by clicking the gray button above the row 1 heading and to the left of the column A heading.

As mentioned previously, you may need to use a different method if your UPC numbers start with a zero. Note that you will need to know how many digits are in the UPC numbers to complete this method.

How to Show Leading Zeroes in Excel

  1. Select the cells with the UPC numbers.
  2. Right-click a selected cell, then choose Format Cells.
  3. Select Custom at the left side of the window.
  4. Click inside the Type field and add a number of zeroes equal to the number of digits in the UPC number.
  5. Click the OK button.

Find out how to make gridlines darker in Excel if you are having trouble viewing the lines around the cells in your spreadsheet.

Matt Jacobs

Matt Jacobs has been working as an IT consultant for small businesses since receiving his Master’s degree in 2003. While he still does some consulting work, his primary focus now is on creating technology support content for SupportYourTech.com.

His work can be found on many websites and focuses on topics such as Microsoft Office, Apple devices, Android devices, Photoshop and more.

Share this:

  • Click to share on Twitter (Opens in new window)
  • Click to share on Facebook (Opens in new window)

Related

Primary Sidebar

Recent Posts

  • How to Show Contact Photos in Messages on an iPhone 11
  • How to Sign Out of Spotify on an iPhone
  • How to Flip a Picture in a Microsoft Word Document
  • How to Announce Messages with Siri on an iPhone 11
  • How to Clear Spotify Cache on an iPhone

Featured Posts

how to rotate the screen on an iPhone 7

How to Rotate the Screen on an iPhone 7

How to Title an Excel Spreadsheet

How to Make Negative Numbers Red in Excel 2013

How Do I Force Microsoft Word to Start a New Page?

How to Draw a Line Through Text in Microsoft Word for Office 365

how to repeat the top row on every page in excel 2013

How to Repeat a Row at the Top Of Every Page in Excel 2013

Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.
To find out more, including how to control cookies, see here: Cookie Policy
  • Privacy Policy
  • Affiliate Disclaimer
  • Contact Us
  • About Us

SupportYourTech.com is a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for sites to earn advertising fees by advertising and linking to Amazon.com.

Copyright © 2021 SupportYourTech.com