Hi

I am very much a nubie to excel macros, so far i have found everything in this forum including this one about adding prefix text to a number, my only problem is that I have a number format "0000" which when i run my macro before using this one i get 0030 so just want to prefix with MJ (MJ0030) but when i add this code it runs with no problems but gives me MJ30 is there a way i can resolve this.

Thanks and kind regards