Hello Dear, It depends offcourse, if receiver has change his or her setting.
If any issue abut the date field then resolve to freeze it, i.e if u r writing 22-jan-2010 u can use freeze ' 22-jan-2010 now receiver will get the correct date, and if he or she want to delimited ‘, then use data ->text to column->delimited by ' I hope this will help. :) Happy to help On Fri, Feb 26, 2010 at 10:48 PM, vikas gupta <[email protected]> wrote: > Thanks a lot friends > > On 26/02/2010, Paul Schreiner <[email protected]> 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 <[email protected]> > > To: [email protected] > > 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 [email protected] > > > > <><><><><><><><><><><><><><><><><><><><><><> > > 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 [email protected] > > > > <><><><><><><><><><><><><><><><><><><><><><> > > 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 [email protected] > > <><><><><><><><><><><><><><><><><><><><><><> > 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 [email protected] <><><><><><><><><><><><><><><><><><><><><><> 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
