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.
Here’s how:
- 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!
Related tips
How to put a zero in front of a number
Display your numbers with leading zeros
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
Karen Roem offers software training and support through her company Roem Ltd. Contact her by email (Karen@roem.co.uk) or visit her website at www.roem.co.uk