Vloop ups

Resolved · Low Priority · Version 2016

Tue 29 Jun 2021, 08:51 Delegate Bede said...

Bede has attended:
Excel Intermediate course

Vloop ups

Please provide some 'learn yourself' material

Tue 29 Jun 2021, 11:34 Trainer Jens said...

RE: Vloop ups

Hi Bede,

Thank you for the forum question.

You will find many very useful videos on Youtube about the Vlookup.

I found a useful one here:
https://www.youtube.com/watch?v=Lw03WcG4mt4

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

Tue 6 Jul 2021: Automatically marked as resolved.

Training courses

	98.8 % recommend us
	More live stats...

Training information:

Excel tip:

Formst Excel to display leading zeroes

Select the cells that you want to have displaying leading zeroes.

From the 'Format' menu select 'Cells' (Or Right-click on the selected range and and select 'Format Cells').

In the 'Number' tab click on 'Custom' in the 'Category' window.

In the 'Type:' box enter zeroes that correspond to the size of the required number (eg 5 zeroes).

Click OK.

When you enter numbers into these cells, leading zeroes will be displayed.

eg 123 = 00123

View all Excel hints and tips