In her regular series for Cambridge Network members, software training expert Karen Roem offers handy tips to help you 'Tame your computer'. This week she explains how to keep the first zero of a telephone number (Microsoft Excel)...
Tame your computer - zero in on phone numbers
Back in May 2018 I told you about one of my bugbears in Excel being that you cannot add a zero in front of a number, which I often want to use for telephone numbers. At the time I told you to type an apostrophe (') in front of the number.
But during a recent Excel training session, one of my delegates shared his way of tackling the fact that 01223214177 should not be turned into 1223214177.
- Add a space after the area code.
For example 01223 214177. If it’s not a landline, simply add a space anywhere. Say, 07941 848326.
Excel will treat the number as text and will leave it exactly as you typed it.
Thanks for this tip, Francois!
Our current course schedule can be found online. Book more than one person from your organisation on the same course, on the same date, and you get 10% off.
22 July 2019
Highly respected training company, specialising in Excel, Word, PowerPoint and Outlook. Since 2001 we have successfully developed and delivered training courses for public and private clients, large and small, across 23 countries around the world. We feel passionate about sharing the best of what we know with others and strive to help as many people as we can.