Char Input w/Multiple IFs

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.

Originally Posted by AlKey

Here is a little bit shorter version

Formula:

=TEXT(LEFT(D2,FIND(".",D2)),"00.")&TEXT(MID(D2,FIND(".",D2)+1,7),"00.0000")

Thank you.

@AlKey

Great stuff. Cheers!