The solution is to use a custom format to reinstate the zeros. So, if you have five digit product numbers, select the cells containing the product numbers, choose Format > Cells > Number tab, and ...

Open the Excel 2010 file that you want to make format changes to. Select the top-left cell in the range of cells that you want to change to the accounting format.

The MOD function in Microsoft Excel lets you work out whether one number is divisible by another. If it's not, it tells you what's left over. For example, if you divide 3 by 2, the MOD function ...

In fourth-grade math, you learned fraction basics: Fractions are a numerical representation of a part of a whole, such as ½, ¾, ... How to format fractions in Excel.

As we mentioned last month, Microsoft Excel 2007 was plagued by a fairly serious math flaw that could affect spreadsheet data. Today, the Excel team at Microsoft has released a patch which ...