Re: Custom Vs Special Date/Time Formats

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

--


Regards,


Peo Sjoblom


<rlistenb@xxxxxxxxx> wrote in message
news:1191850581.735719.196010@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
On Oct 5, 6:10 pm, Pete_UK <pashu...@xxxxxxxxxxx> wrote:
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.



.

Relevant Pages

  • RE: Regional settings modification
    ... Country Text Indexed ... This application is intended for different countries and differend currency ... They are still derived from the regional settings. ... simply copied the pound symbol and used it in the format property for text ...
    (microsoft.public.access.modulesdaovba)
  • Re: question about conversion
    ... Dates (even in SQL Server) are always stored *internally* the same way. ... problem is that as soon as a date is written down each country have its own ... (YYYYMMAA that is always read correctly regardless of regional settings) ... Sql Server (date is saved in dd/mm/yyy format in datetime field). ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: NumberFormat does not change the label format
    ... In fact nothing in the regional settings seems to have any affect on ... the format of the graph dates. ... With axis type set to chAxisGroupingTypeNone, ...
    (microsoft.public.office.developer.web.components)
  • Re: Format an Excel Column in the windows short date format.
    ... Excel Internation properties lead me to construct: ... date format string I build from the excel properties to excel via the ... It works for most regional settings but not Norwegian. ...
    (microsoft.public.excel.programming)
  • Re: What prefix for Las vegas??
    ... operating agreements specify amateur station ID as: ... Relating to the Operation by Citizens of Either Country ... amateurs must carry proof of their US citizenship and their valid US ... so the preferred format would be W7/G3XYZ ...
    (uk.radio.amateur)