Date and Time display

C

Chiropter

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

Paul B

Chiropter, format, cells, custom, mm/dd hh:mm
--
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
 
P

Paul B

Your Welcome

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot table macro filter data between yesterday and today (date+time) 0
Date and Time Conversion 3
How to enter start and end date/time in excel based on some specific value. 7
Computing Elapsed Time 4
Dates in Excel 2003 1
Getting MM-DD HH:MM out of Julian date 4
Date format problems after csv import 2
Date & Time Format 7

Top