Tag Archives: Microsoft Excel 2010

Microsoft Excel – inputting mobile numbers in a specific format

I was recently asked how to get mobile numbers in the format XXXX XXX XXX in an Excel worksheet. The answer is leave the column in which the mobile numbers are to be input formatted as General. Go to the … Continue reading

Posted in Microsoft Excel, Microsoft Excel 2003, Microsoft Excel 2007, Microsoft Excel 2010 | Tagged , , | 2 Comments

Using Conditional Formatting to find duplicate data in Microsoft Excel

If you have duplicate data in a workbook, it is good to be able to see what that duplicate data is, before deciding whether or not to delete it. In Microsoft Excel versions 2007 onwards, conditional formatting can be used … Continue reading

Posted in Microsoft Excel, Microsoft Excel 2007, Microsoft Excel 2010, Microsoft Excel 2013, Microsoft Excel 2016 | Tagged , , , | Leave a comment