Thanks a lot friends On 26/02/2010, Paul Schreiner <schreiner_p...@att.net> wrote: > > > The date display format is determined by the Personal Settings for the PC > that opens the file > (it is not stored in the file) > that means, IF THE CELL IS A VALID DATE > then you can have the PC you're using currently display the date as: > DD/MM/YYYY, and then open the file on another PC and display it > differently. > > However, You must be using the "default" date format you set up in your > Excel settings, > and the dates must be actual Excel dates, not text strings that look like > dates. > > If you format he cells to a different date format (like using right-click, > format cells) > then you are telling Excel to override he default and use a specific format. > > So, when you open it in France, it will still override the defaults. > > Paul > > > ________________________________ > From: vikas gupta <vikas.63...@gmail.com> > To: excel-macros@googlegroups.com > Sent: Fri, February 26, 2010 7:40:10 AM > Subject: $$Excel-Macros$$ CHANGE IN DATE FORMAT IN EXCEL > > DEAR ALL > > GREETINGS OF HOLI FESTIVAL > > I HAD SENT A EXCEL FILE THROUGH E MAIL FROM DELHI TO FRANCE > IN EXCEL FILE A DATE IS WRITTEN IN DD/MM/YYYY FORMAT > BUT WHEN IT REACHED ITS DESTINATION IT SHOWS THE DATE FORMAT > IN MM/DD/YYYY FORMAT > > IS IT POSSIBLE IN EXCEL SHEET > > PLEASE PROVIDE ME SOLUTION URGENTLY > > THANKS IN ADVANCE > > REGARDS > VIKAS GUPTA > 09311334683 > > -- > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our Facebook Group @ > http://www.facebook.com/group.php?gid=287779555678 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > HELP US GROW !! > > We reach over 6,800 subscribers worldwide and receive many nice notes about > the learning and support from the group.Let friends and co-workers know they > can subscribe to group at > http://groups.google.com/group/excel-macros/subscribe > > -- > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our Facebook Group @ > http://www.facebook.com/group.php?gid=287779555678 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > HELP US GROW !! > > We reach over 6,800 subscribers worldwide and receive many nice notes about > the learning and support from the group.Let friends and co-workers know they > can subscribe to group at > http://groups.google.com/group/excel-macros/subscribe >
-- Sent from my mobile device -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
