Date format problem

rjagathe

Guest

Posts: n/a

4th Mar 2010

In my Excel files,when I click a cell that contain "date" it changes
into dd/mm/yyyy format.But,in the formula bar,the same date is
displayed in mm/dd/yyyy format.Why it is so?
I want all the dates in dd/mm/yyyy format only.Will there be any
problem while sorting if the date column contais dates of different
formats i.e. dd/mm/yyyy and mm/dd/yyyy as well?

« MS Excel 2003 - Advanced Features Add-In | Visual Basic Editor Opening and Closing for User »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Excel Format Problem - Date Overrides Format	Mary	Microsoft Excel Misc	5	10th Feb 2010 05:49 AM
[Newbie UK Date problem] Ways atround this UK date format localisation/SQLselection issue?	DC	Microsoft ASP .NET	5	1st Jul 2005 10:35 PM
[Newbie UK Date problem] Ways atround this UK date format localisation/SQLselection issue?	DC	Microsoft C# .NET	5	1st Jul 2005 10:35 PM
Date Format problem	Mervyn Thomas	Microsoft Excel Programming	1	12th May 2005 05:52 PM
Date format problem	Nishant	Microsoft Excel Misc	4	17th Sep 2003 11:40 PM