How to work on a formula to display 2 digit value?
With reference to the above, we are trying to create a Serial Number with a few combination of data. One of it is the month and year submitted.
I am using the MONTH(@cell) and YEAR(@cell) formula (as shown in the screenshot) to obtain the month and year.
Is there any formula to convert it into a 2 digit value as follows?
Month: 01, 02, 03, 04, 05, 06, 07, 08, 09, 10, 11, 12
Year: 22 for 2022, 23 for 2023 ...
Help Article Resources
Check out the Formula Handbook template!