Formatting Cells

[mango2015]

Hi,

Earlier today someone helped me with the macro I am using for my spreadsheet, but I've come across a small problem that I can't seem to solve.

The macro is assigned to a button and once pressed it adds numbers in a sequence to the sheet. But I can't seem to get the number (which is suppose to be a purchase order number.) in the correct format I use at work.

I've attached a sample spreadsheet and, in the sheet called 'log' you will notice that in the 'P/O NO' column the numbers follow a sequence, BA07691, BA07692, etc.. but in cell B16 it jumps to BA17690. I would like it to carry on following the sequence, so when it reaches BA07699 the next number would be BA07700 and so on. Would really appreciate some help on this, I'd imagine it is something fairly straight forward?

The format I am using is: "BA"-07690

Although I have tried other variations.

Gus

[LeoTaxi]

did some changes in userform


Kind regards
Leo

[mango2015]

Thank you Leo, that is more than I expected I really appreciate it. It works great.

Gus