auto numbering with a part of text

[already]

Hi All,

I'm using the following formula to auto number invoices with a macro.

Range("A10").Value = Range("a10").Value + 1

But if I use inv001 it give me a mismatch error.

and if I use only 001 the invoices are numbered without the leading zero's.

I prefer the inv001 numbering and the text should be in the same cell as the number.

Any work around for this?

Thanks in advance

Kind regards

Al

 

[dmt32]

Hi,
create a custom format should do what you want:

Select the Cell you want to Format then From Home Tab

Format > Format Cells > Custom

Enter "Inv"000


Press OK.

Hopefully, your macro should now increment cell value as required.

Dave

 

[already]

Hi Dave,
Thanks! I didn't thought on this
Kind regards
Al