My organization recently changed its number system for our case files from four digits to five digits. The former included a four digit case number, followed by a dash, followed by the four digit year, then another dash, and finally the three digit office identifier (ie: 0100-2014-035). The attached spreadshet contains a sample of historical data I must maintain for a rolling 5 fiscal years. Can anyone describe to me a formula where I can simply add a leading sero to our case number?
Thank you!
Bookmarks