 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / October 2007Custom Vs Special Date/Time Formats
I have several Excel files that use a custom D/T format. Issue is when used by regions where they prefer a different format (d/m/y vs. standard US m/d/y). Instead of keeping two versions of each report, is there a way to create a Special D/T format? I am currently using mm/dd/yyyy hh:mm:ss As there is not existing Date & Time (combined) format, I have to use custom. Any thoughts?? Are you talking about different countries? If so, you can use the US format and they will be converted to the regional formats automatically. I believe d/m/y is UK date format and maybe Canada I am not sure  SignatureRegards, Peo Sjoblom >I have several Excel files that use a custom D/T format. Issue is > when used by regions where they prefer a different format (d/m/y vs. [quoted text clipped - 9 lines] > > Any thoughts?? Will the regional settings take care of this? Can you send the file to someone in a country that uses the d/m/y format to see how the cells are displayed? I just typed in 15/10/07 10:15 and it was displayed how I expected, but I think I've set up a custom format for that in the past. Hope this helps. Pete On Oct 5, 11:37 pm, rlist...@gmail.com wrote: > I have several Excel files that use a custom D/T format. Issue is > when used by regions where they prefer a different format (d/m/y vs. [quoted text clipped - 9 lines] > > Any thoughts?? > Will the regional settings take care of this? Can you send the file to > someone in a country that uses the d/m/y format to see how the cells > are displayed? > > I just typed in 15/10/07 10:15 and it was displayed how I expected, > but I think I've set up a custom format for that in the past. Pete, CUSTOM date formats will NOT adapt to different "regional settings" in Windows. That is the entire issue I am asking about. I need to know if there is a way to "embed" a date/time format into an excel workbook. Why would you need to do that? If you send someone in another country with another regional settings a file it will be converted automatically unless it is text. As long as you use what Excel recognizes as dates it will be converted SignatureRegards, Peo Sjoblom >> Will the regional settings take care of this? Can you send the file to >> someone in a country that uses the d/m/y format to see how the cells [quoted text clipped - 7 lines] > need to know if there is a way to "embed" a date/time format into an > excel workbook. > Why would you need to do that? If you send someone in another country with > another regional settings a file it will be converted automatically unless [quoted text clipped - 6 lines] > > Peo Sjoblom Not when using CUSTOM formats. The bottom line question I am attempting to get an answer to is .... Can I add a date/time format into Excel's native formats? (Currently there are DATE format and TIME format, but </b> NO DATE/ TIME formats NATIVE to Excel.</b>)
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.