Apply the TEXT function. 1] Add an apostrophe before the number One of the easiest methods to stop Excel from deleting leading zeros is to insert an apostrophe before the actual number.

This screenshot guide shows you hwot to create, customize and insert a watermark in Microsoft Excel using two different methods.

Learn how to suppress or hide zero values in an Excel sheet using one of these quick and easy methods.

You can insert blanks rows above or below another in Excel, and you can even add them between each row that has data.