If i have a column that contains a mix of '29/09/2012' format with 22-22-22 format (date and sort code) and i want to change all the date formats to sort code format (simply changing the / to -) how can i do this in a quick process?
If i have a column that contains a mix of '29/09/2012' format with 22-22-22 format (date and sort code) and i want to change all the date formats to sort code format (simply changing the / to -) how can i do this in a quick process?
Office 2010 user.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks