Office Software Thread, Excel Data Sorting in Technical; Hi there,
I have a spreadsheet with loads of data on and that needs to be sorted by date of ...
26th March 2012, 12:21 PM #1
Excel Data Sorting
I have a spreadsheet with loads of data on and that needs to be sorted by date of birth, excluding the year! The DoB's are entered as 13/06/05 (D/M/Y) but I need to sort them into just D/M.
Can this be done?
26th March 2012, 12:28 PM #2
You can use the TEXT() function to format dates and extract just the parts you are interested in. So =TEXT(<cell>, "dd/mm") should give you just the day and month.
Thanks to pcstru from:
bodminman (26th March 2012)
By CatherineMay in forum AV and Multimedia Related
Last Post: 6th July 2011, 03:39 PM
By ful56_uk in forum Office Software
Last Post: 31st December 2010, 12:04 PM
By rocknrollstar in forum Office Software
Last Post: 15th September 2008, 07:21 PM
By harvy28 in forum Hardware
Last Post: 28th April 2008, 11:32 AM
By danIT in forum General Chat
Last Post: 14th February 2008, 02:14 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)