Im trying to enter a formula into a column so that when data is added to that row an ID number is automatically displayed.
The ID number consists of
-A letter which is the 1st letter of our store eg M
-Period number eg 5
-2 digit Year e.g 19
-3 digit receipt number eg 026
SO altogether it will be M519026
i have come up with the following however i cant figure out how to turn the receipt number back to 001 when the period number changes.
hopefully somebody can figure it out, there is probably an even more simple way to do it, if so also please let me know
Thanks Martin
Bookmarks