C
Connie
How do I format cells for dates so that when I type 3-11
it returns "Tue 11-Mar-04"?
it returns "Tue 11-Mar-04"?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
C
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
Use a custom number format of ddd dd-mmm-yy .
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
M
Mary
Go to format cell, custom, and type ddd dd-mmm-yyyy in
box.
HTH
box.
HTH
N
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
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
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
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
A
Andy B
Connie
You can't. 11 Mar 2004 is a Thursday!! <g>
Try this:
ddd dd-mmm-yy
Andy.
You can't. 11 Mar 2004 is a Thursday!! <g>
Try this:
ddd dd-mmm-yy
Andy.
P
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 **
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 **
C
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
Wish it were March 11th!! We'd be that much closer to
spring! Connie
P
Peter Atherton
Connie
Select the date range and choose Format, Cells, Custom and
in the custom text box type ddd mmm yy
Regards
Peter
Select the date range and choose Format, Cells, Custom and
in the custom text box type ddd mmm yy
Regards
Peter