Invoice number

[karthikeyan9380]

My excel invoice number SW-BAN/DN/18-19/1557 and running is only last 4 digits (1557), can anybody help to given macro code changing that 4digits

 

[silentwolf]

Hi,
so you like to keep everything befor the last 4 digits?

SW-BAN/DN/18-19/1558

and how you like to change it? Well a little more information would be nice so someone can help you better...

 

[karthikeyan9380]

Hi,
so you like to keep everything befor the last 4 digits?

SW-BAN/DN/18-19/1558

and how you like to change it? Well a little more information would be nice so someone can help you better...

"LAST 4digits is running number i.e 1,2,3,4...9999