In this tutorial, I am going to look at how to add a zero or multiple zeros in front of a number in Excel. When you want to store a number with a leading zero, it needs to be stored as a text value, as numeric values cannot start with a zero. We will look… Read More »How to Add a Zero In Front of a Number in Excel
In this Microsoft Excel tutorial, I will explain how to copy and paste or cut and paste visible cells, excluding hidden rows and columns. Download the featured file here. METHOD 1: Select all your data: select one cell in your data and use the shortcut key CTRL A Then use the shortcut key CTRL G… Read More »Paste Visible Cells Only in Excel
In this video tutorial we will look at two methods for capitalising the first character of each word within a cell. Method 1: Flash Fill To use Flash Fill to capitalise the first letter of each word in a column: In a cell adjacent to the cell containing your text, type that text with capitalised… Read More »Capitalise First Letter of Each Word in Excel Cell