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
Independent, innovative software training company based in Cambridge. Registered supplier to local companies such as AstraZeneca, University of Cambridge, South Cambridgeshire District Council and NHS England.