Hello -
I would like to change the dates from this format 1/1/2011 (m/d/yyyy) to this format 01012011 (mmddyyyy). I have been trying formatting the cell as mm/dd/yyyy and then following this with the ctl+H to remove the dashes, but it is also removing the leading zero's. What is a quick and efficient way to format the cells with dates?
Thanks in advance!
Bookmarks