hi, in Excel, basically, a date is an unique number. The number remains the same irrespective of its format. If the date is a manual writing, sometime it often happens that we insert some unwanted characters while typing and the sorting gets affected.
On 4/18/15, Swarna Badrinath <[email protected]> wrote: > Hi Himanshu, > > You can change the date to "1-Apr-14" format and apply auto filter. > You can activate Date filter submenu and key in the requirements and > extract the needed data. > > Regards, > Swarna. > > On 4/18/15, Mahesh Narasimhan <[email protected]> wrote: >> Dear Himanshu, >> >> I guess that the date has to be changed to MMDDYY format because excel >> recognises MMDDYY as date and not DDMMYY format. Then you try to sort, >> it would help then. >> >> All the best! >> >> -- >> Good friendship is like the relationship between eye & hand! If the >> hand is hurt, the eye will cry! & when the eye cries, the hand will >> wipe the tears!!! >> With best regards, >> Mahesh Narasimhan >> M: +91(0)9899353960 >> E: [email protected] >> >> >> >> On 4/18/15, Himanshu Sahu <[email protected]> wrote: >>> Dear Friends, >>> Please suggest me the option for doing the following in Excel Sheet. >>> >>> I have a document containing 20 columns and 4000 rows. >>> In the column "g" various dates for one event is mentioned. These >>> dates begin from 1st April 1985 to the 31st march 2015. >>> The date format is DD/MM/YYYY. >>> I need to extract data beginning from 1st April 2014 to 31st March 2015. >>> I tried "sorting" option in descending order, but it is not sorting >>> data as desired, e.g., after searching 31st March 2015 data, it is >>> showing the data of 31st march 2014, 31st march 2013 and so on... >>> So, please suggest the way to get data of above mentioned period only >>> i.e., 01/04/2014 to 31/03/2015. >>> >>> Another problem is also related to the same condition: >>> >>> All of these dates which start from 1 to 9 of the month day, are >>> mentioned in D/M/YYYY format, e.g., 1/1/2015 . Even I tried to make >>> them uniform manually like 01/01/2015, but the document setting is not >>> allowing it. >>> So, here my query is: >>> 1. How to make this date format uniform like DD/MM/YYYY? >>> 2. Even without making it uniform, can we extract the data as >>> mentioned above? If yes, then how? >>> >>> Looking for your positive response... >>> >>> -- >>> Thanks and regards >>> Himanshu Sahu >>> Reach: 09051055000 >>> Skype: himanshu.cute4u >>> >>> >>> >>> Register at the dedicated AccessIndia list for discussing accessibility >>> of >>> mobile phones / Tabs on: >>> http://mail.accessindia.org.in/mailman/listinfo/mobile.accessindia_accessindia.org.in >>> >>> >>> Search for old postings at: >>> http://www.mail-archive.com/[email protected]/ >>> >>> To unsubscribe send a message to >>> [email protected] >>> with the subject unsubscribe. >>> >>> To change your subscription to digest mode or make any other changes, >>> please >>> visit the list home page at >>> http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in >>> >>> >>> Disclaimer: >>> 1. Contents of the mails, factual, or otherwise, reflect the thinking of >>> the >>> person sending the mail and AI in no way relates itself to its veracity; >>> >>> 2. AI cannot be held liable for any commission/omission based on the >>> mails >>> sent through this mailing list.. >>> >> >> >> >> Register at the dedicated AccessIndia list for discussing accessibility >> of >> mobile phones / Tabs on: >> http://mail.accessindia.org.in/mailman/listinfo/mobile.accessindia_accessindia.org.in >> >> >> Search for old postings at: >> http://www.mail-archive.com/[email protected]/ >> >> To unsubscribe send a message to >> [email protected] >> with the subject unsubscribe. >> >> To change your subscription to digest mode or make any other changes, >> please >> visit the list home page at >> http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in >> >> >> Disclaimer: >> 1. Contents of the mails, factual, or otherwise, reflect the thinking of >> the >> person sending the mail and AI in no way relates itself to its veracity; >> >> 2. AI cannot be held liable for any commission/omission based on the >> mails >> sent through this mailing list.. >> > > > > Register at the dedicated AccessIndia list for discussing accessibility of > mobile phones / Tabs on: > http://mail.accessindia.org.in/mailman/listinfo/mobile.accessindia_accessindia.org.in > > > Search for old postings at: > http://www.mail-archive.com/[email protected]/ > > To unsubscribe send a message to > [email protected] > with the subject unsubscribe. > > To change your subscription to digest mode or make any other changes, please > visit the list home page at > http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in > > > Disclaimer: > 1. Contents of the mails, factual, or otherwise, reflect the thinking of the > person sending the mail and AI in no way relates itself to its veracity; > > 2. AI cannot be held liable for any commission/omission based on the mails > sent through this mailing list.. > -- Him Prasad Gautam Kathmandu, Nepal Register at the dedicated AccessIndia list for discussing accessibility of mobile phones / Tabs on: http://mail.accessindia.org.in/mailman/listinfo/mobile.accessindia_accessindia.org.in Search for old postings at: http://www.mail-archive.com/[email protected]/ To unsubscribe send a message to [email protected] with the subject unsubscribe. To change your subscription to digest mode or make any other changes, please visit the list home page at http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in Disclaimer: 1. Contents of the mails, factual, or otherwise, reflect the thinking of the person sending the mail and AI in no way relates itself to its veracity; 2. AI cannot be held liable for any commission/omission based on the mails sent through this mailing list..
