How to best convert Excel date to MMDD in another cell?
Posted on 2013-11-06
I currently have an Excel document with a column of dates. I need to end up with a new column that has the date (only month and day) in 4 digits, and must include leading 0s. I'm able to extract the day and month in separate columns using the relevant functions (day/month) and can add the leading 0 by changing the format.
However, when I attempt to concatenate the two fields, the leading 0s drop out. Is there any way to accomplish what I need?