Hello, everyone!
I am trying to create a spreadsheet to track action items for contract task orders. To make things easier for me to avoid formatting mistakes (the spreadsheet will be editable by more than just me) I would like to create a custom formatting that takes an entered ID number - e.g., 1 - and turns it into a unique alphanumeric action item number in the following format: TO##-YYYY-ID#. E.g., TO01-2019-001. The task order number will be specified in another cell on the worksheet.
What I tried in the custom format field was: "TO"TEXT(A1)"-"yyyy"-"000
Excel didn't take the formatting.
Next I tried "TO01-"yyyy"-"000
Excel didn't take the formatting.
Next I tried "TO01-"yyyy"-"General
Excel took the formatting. However, when I used 15 as the ID number to test a number greater than 10 I received the following string: TO01-1900-0.5
Clearly, there are two issues with that - it's not 1900, and 0.5 =\= 15.
Please help.
I am trying to create a spreadsheet to track action items for contract task orders. To make things easier for me to avoid formatting mistakes (the spreadsheet will be editable by more than just me) I would like to create a custom formatting that takes an entered ID number - e.g., 1 - and turns it into a unique alphanumeric action item number in the following format: TO##-YYYY-ID#. E.g., TO01-2019-001. The task order number will be specified in another cell on the worksheet.
What I tried in the custom format field was: "TO"TEXT(A1)"-"yyyy"-"000
Excel didn't take the formatting.
Next I tried "TO01-"yyyy"-"000
Excel didn't take the formatting.
Next I tried "TO01-"yyyy"-"General
Excel took the formatting. However, when I used 15 as the ID number to test a number greater than 10 I received the following string: TO01-1900-0.5
Clearly, there are two issues with that - it's not 1900, and 0.5 =\= 15.
Please help.