click the show formulas button

How to Hide Formulas in Excel 2013

Formulas are one of the most useful features of Microsoft Excel, as it allows you to easily perform assorted operations on your data. Formulas can then be copied from single cells and applied to multiple cells, allowing you to quickly calculate a large number of mathematical operations that would take a long time to perform … Read more

select number, then change decimal places to zero

How to Format UPC Codes in Excel

Excel is a great option for storing information about products that your company sells. But you may run into a problem where you need to learn how to format UPC codes in Excel, as it will commonly convert them so that they display as scientific notation. The data is still stored correctly in Excel, but … Read more