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 wrote:
> Hi Hi
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 wrote:
> Dear Himanshu,
>
> I guess that the date has to be changed to MM
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!
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/.
I need