Hi all,

I would like to change the formatting of a cell containing a date/time
stamp. It defaults to m/d/yyyy h:mm, but I would like to format to something
like 10/11/2005 11:40:36 PM - The default displays 10/11/2005 23:40.

Thanks.

-Martin

Hi Martin, it is easy to see the code behind this task by recording a
macro, performing the task manually, and after it is recorded press
'Alt' + 'F11' (Open the VBA Editor).

HTH--Lonnie M.

Thanks for your help Lonnie, thats just what I was looking for!

-Martin

"Lonnie M." wrote in message
oups.com...
Hi Martin, it is easy to see the code behind this task by recording a
macro, performing the task manually, and after it is recorded press
'Alt' + 'F11' (Open the VBA Editor).

HTH--Lonnie M.

[$-409]m/d/yy h:mm AM/PM;@

format cell Time select, then select formatcustom to see the formating code
above

"Martin" wrote:

Hi all,

I would like to change the formatting of a cell containing a date/time
stamp. It defaults to m/d/yyyy h:mm, but I would like to format to something
like 10/11/2005 11:40:36 PM - The default displays 10/11/2005 23:40.

Thanks.

-Martin