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
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
No comments:
Post a Comment