Hi,
I have a whole colum of figures in column H of which some are correct and some are not.
Basically I need a little macro/function which looks for any numbers in column H which are 7 digits long and puts a "0" in front of them. However, if the number is 8 digits long then it does nothing (as it SHOULD be 8 digits). I have already changed the format to Text Only (otherwise I am aware that the 0 will disappear again.
Help?!?!?!?!?