Wednesday, August 1, 2012

yogi_Generate Unique Identifier With Specific Format In Sheet

Yogi Anand, D.Eng, P.E.       Google Spreadsheet    Post  #665   Aug 01, 2012     www.energyefficientbuild.com.


user Vinnie 2 said:(http://productforums.google.com/forum/#!category-topic/docs/spreadsheets/c-bgUwMSfac)
How to auto generate a unique identifier number with specific format in spreadsheets ?
 I was trying to auto generate a serial number list starting with '0001/12' format, where 0001 stands for serial number and 12 stands for year 2012. I tried with function =0001/12 in A1, the result was a divided number. How could I generate a serial number with above format without division. 
------------------------------------------------------------------------------------------
following is a solution to a bit more generalized problem