Custom Vs Special Date/Time Formats

  • Thread starter Thread starter rlistenb
  • Start date Start date
R

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??
 
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
 
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
 
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.
Click to expand...
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

--


Regards,


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
Click to expand...

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