Formerly Best Training
© 2024 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE
2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT. United Kingdom
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Numbers
Resolved · Low Priority · Version 2016
Lylia has attended:
Excel Intermediate course
we learnt that to add a telephone number starting with 0, we should add an apostrophe first.
What if the number starts with +44...
Hi Lylia,
Thank you for the forum question.
It is the same as starting with a zero. If you not format it as text Excel will remove the + sign.
Just format the column as Text or enter a apostrophe before the +, then Excel will keep the the +.
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
Wed 13 Jun 2018: Automatically marked as resolved.
|
Excel tip:Editing a formula quicklyIf you want to edit a fomrula or text quickly witin a cell instead of the formula bar, you can click either double click in the cell or press the F2 key |
We'll call during UK business hours
Server loaded in 0.07 secs.