One of the easiest methods to stop Excel from deleting leading zeros is to insert an apostrophe before the actual number. The number will be displayed without the apostrophe symbol.

Learn how to ignore zero values in Excel charts with step-by-step tips to create clean, accurate, and professional visuals.

Averaging in Microsoft Excel is easy, until you start excluding specific values. Here are three ways to average a data set when giving special consideration to the highest and lowest values.