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
