is there a way for me to do a custom format in excel that will convert the date from 1/5/2011 to 1/1/2011. so basically I am trying to keep the following format : mm/01/yyyy. I tried entering this as a custom format but it did not work. Thanks