How to lead zero with single month and day return?
Question is now on brief
Suppose Cell A1 contains 42 Years, 2 Months, 3 Days, how do I tell excel to return 42 Years, 02 Months, 03 Days in Cell A2. Similarly for the following inputs :
15 Years, 6 Months, 13 Days : 15 Years, 06 Months, 13 Days
21 Years, 11 Months, 5 Days : 21 Years, 11 Months, 05 Days
52 Years, 10 Months, 12 Days : 52 Years, 10 Months, 12 Days
The output should contain length of 28 characters.
Excel file attachment is available
Attachment | Size |
---|---|
example.xlsx | 10.61 KB |
re your Excel formula question
Hi, could you send me the file so I can see if all entries are similar to the ones you posted