Custom Vs Special Date/Time Formats

[rlistenb]

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??

 

[Peo Sjoblom]

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


--


Regards,


Peo Sjoblom

 

[Pete_UK]

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

 

[rlistenb]

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.

 

[Peo Sjoblom]

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]

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

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>)