karthikeyan9380

New Member
Joined
Jan 5, 2019
Messages
2
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
 

Some videos you may like

Excel Facts

Which came first: VisiCalc or Lotus 1-2-3?
Dan Bricklin and Bob Frankston debuted VisiCalc in 1979 as a Visible Calculator. Lotus 1-2-3 debuted in the early 1980's, from Mitch Kapor.

silentwolf

Well-known Member
Joined
May 14, 2008
Messages
1,123
Office Version
  1. 2016
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

New Member
Joined
Jan 5, 2019
Messages
2
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
 

Watch MrExcel Video

Forum statistics

Threads
1,108,809
Messages
5,525,002
Members
409,615
Latest member
papaluigi94

This Week's Hot Topics

Top