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 Format Cells Number tab and click Custom. Type in 0000″ “000” “000
This means that if you now type in a mobile number such as 0432117628 it will automatically show as 0432 117 628.