Formatting Date

[Connie]

How do I format cells for dates so that when I type 3-11
it returns "Tue 11-Mar-04"?

 

[Chip Pearson]

Connie,

Use a custom number format of ddd dd-mmm-yy .


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[Mary]

Go to format cell, custom, and type ddd dd-mmm-yyyy in
box.

HTH

 

[Norman Harker]

Hi Connie!

Use custom format:

ddd dd-mmm-yy

But you'll need a formula to get it to show Tue 11-Mar-2004 because
it's a Thursday <vbg>

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[Andy B]

Connie

You can't. 11 Mar 2004 is a Thursday!! <g>

Try this:

ddd dd-mmm-yy

Andy.

 

[Paul B]

Connie, format the cell as custom ddd dd-mmm-yy, but march 11 is a Thursday
not a Tuesday
--
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 97 & 2000
** remove news from my email address to reply by email **

 

[Connie]

Thank you everyone! I'm really ahead of myself, though!!
Wish it were March 11th!! We'd be that much closer to
spring! Connie

 

[Peter Atherton]

Connie

Select the date range and choose Format, Cells, Custom and
in the custom text box type ddd mmm yy

Regards
Peter