DatesMMDD.xls

<div>
<div class="content wysiwyg-content">
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.<br />
<br />
However, when I attempt to concatenate the two fields, the leading 0s drop out. Is there any way to accomplish what I need?<br />
<br />
Thanks!
</div>
</div>


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?

Thanks!

How to best convert Excel date to MMDD in another cell?

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.