Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Solutions Through Learning

Excellent

Request Callback We will call you back

0207 987 3777 Call for assistance

Your Basket Basket is empty

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Numbers

Numbers

ResolvedVersion 2016

Tue 5 Jun 2018, 16:46 Delegate Lylia said...

Lylia has attended:
Excel Intermediate course

Numbers

we learnt that to add a telephone number starting with 0, we should add an apostrophe first.
What if the number starts with +44...

Wed 6 Jun 2018, 08:48 Trainer Jens said...

RE: numbers

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:

Separate the year from a date

To separate the year from a date use the =year() function, eg a date is in cell A1 and in A2 you wish to display the year enter the function =year(A1)

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Numbers

Numbers

RE: numbers

Excel articles

Excel tip:

Separate the year from a date