Excel Formula to convert dd/mm/yyyy to mm/dd/yyyy

Convert dd/mm/yyyy to mm/dd/yyyy in Excel (with Images) What is it? By default Excel Date format is mm/dd/yyyy. There is a bigger challenge due to this default format! What if you save a date in dd/mm/yyyy format 1/7/2014 (1st July 2014) but Excel will read it as January, 7, 2014 (1/7/2014). The…

Continue reading