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

[6StringJazzer]

You are trying to do arithmetic by using a custom format and that just isn't going to work. Since you're already using a macro, you should modify the macro to generate the P/O numbers just how you need them. Use this code, which I tested in your file:

Please Login or Register  to view this content.

[mango2015]

I'm fairly new to macros, don't really know too much about them. But I appreciate your help, the code works just as I wanted.

Thank you.

Gus