Listing contact details

Hi Annika,

Thank you for using the forum to ask a question.

Method 1
You can format the cell as Text

Method 2
Format Cells (Ctrl 1)
Choose Custom
Type in the box 7 - 10 zeros (each stands for a digit)
When you use the cell to type in a number it will always display this number of digits including zeros.


Kind regards

Richard Bailey
Microsoft Certified Trainer

Best 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