Ewhen's IT Blog: Format "whenCreated" & "whenChanged" CSVDE Fields in Excel

Monday 19 July 2010

Format "whenCreated" & "whenChanged" CSVDE Fields in Excel

The formula you need to use is;

=MID(D10,7,2)&"/"&MID(D10,5,2)&"/"&LEFT(D10,4)

3 comments:

Kevin said...: Cheers.; 9 June 2012 at 20:03
Paul said...: Very useful, thanks for sharing this!; 14 June 2012 at 10:31
skibby said...: Seems like the months and days are displayed backwards?; 25 October 2012 at 17:08

Subscribe to: Post Comments (Atom)