Date and Time display

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Chiropter - 23 Feb 2007 17:45 GMT

In older Excels it was possible to edit or write a new format to express
date and time in a desired way. Now in Excell 2000 there is no such
function offered in Format Cells/Date and Time.
Because of space displayable within the monitor space, I want to show
date and time as below:
MM/DD HH:MM (no year, military time, no seconds)
for example
02/23 11:38

Can I do this without going into laborious programing?

Reply to this Message

Paul B - 23 Feb 2007 17:56 GMT

Chiropter, format, cells, custom, mm/dd hh:mm

Signature

Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

> In older Excels it was possible to edit or write a new format to express
> date and time in a desired way. Now in Excell 2000 there is no such
[quoted text clipped - 6 lines]
>
> Can I do this without going into laborious programing?

Reply to this Message

Chiropter - 23 Feb 2007 18:18 GMT

Thank you

> Chiropter, format, cells, custom, mm/dd hh:mm

Reply to this Message

Paul B - 23 Feb 2007 19:54 GMT

Your Welcome

Signature

Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

> Thank you
>> Chiropter, format, cells, custom, mm/dd hh:mm

Reply to this Message