dateconvert

  1. B

    Date format 8/8/08 (m/m/yyyy) to dd/mm/yyy

    Hi Guys, I have imported some raw unformatted data into in excel and the date comes in as eg 8/8/08, 6/12/08, 12/9/08 in the US format. When I do a date format on it 6/12/08 could be 6th Jan 2008 instead of 12 Dec 2008 etc.. Is there a way of acurately formatting as dd/mm/yyyy? Thanks

Some videos you may like

This Week's Hot Topics

Top