Add 0 to start of number if length is less than 5

[chrisellis250]

Hi all,

I've attached a workbook with one sheet on it called "Survey Location Table".

I am looking to add a 0 to front of any number, where the length of the value in an individual cell is less than 5 digits.

The cells in question will be from Column D onwards.

So where a number is 8774, as shown in Cell E10 then this should become 08774.

This still applies if a number is 3 digits long, like shown in Cell E70 then this should become 0901.

IF numbers are 5 digits long then nothing is to happen with them.


Any one have any ideas?

Many thanks,