Hello,
I have an input data for dates in a text (General) format in dd/mm/yyyy format with the only exception that it does not have "0" in front of the single digit numbers for the corresponding days and months (e.g. 1.3.2017, 11.3.2017, 11.3.2017 etc.).
I will appreciate your help on making those single digit numbers a two digit number with 0 being the first digit. Not sure if multiple nested IFs w/Concatenate formula is the most intelligent solution here. I tried building such type of formula, but haven't been able to obtain all of the cases. There's probably more clever approach to use.
Please find attached a spreadsheet with example.
Thanks in advance.
Bookmarks