Can anyone assist in a basic query, I have column A of data, in numerical format, i.e. 887766, what has happened is the data provided has stripped leading 0's. Every value should have 8 numbers, so if it currently is 6 characters long, it needs 00 adding to the front of the sequence, if it is 5 characters long, it needs 000 addidng to the front of the sequence. If it is 8 characters long nothing needs to change. Any ideas?