Microsoft's spreadsheet program can do way more than you might realize. These are the hacks and tricks you need to know.

So, open the Excel file, highlight the relevant data, right-click, and select Copy. Click Ctrl+N to open a new blank workbook, and choose Paste Special to remove the formatting.

If you are trying to import an existing Excel file to your workbook without removing leading zeros, go to the Data tab and click on the Get Data > From File > From Excel Workbook option.

Learn how to use a data validation control to allow users to select when to run multiple VBA procedures in Microsoft Excel.