how to insert month date year and day of week
 

I use Win XP Home Edition, SP2, Excel 2003

Can someone inform me how to put Month, date, year and day of the week in
cell. I'd like to insert for example, 05/18/06 Wed

how to insert month date year and day of week
 

<format<cells<number<custum
enter
mm/dd/yy ddd

"Sachi Noma" wrote:

I use Win XP Home Edition, SP2, Excel 2003

Can someone inform me how to put Month, date, year and day of the week in
cell. I'd like to insert for example, 05/18/06 Wed

how to insert month date year and day of week
 

With 5/18/06 in cell A1;
Format, cell custom m/d/yy ddd

"Sachi Noma" wrote in message
:

I use Win XP Home Edition, SP2, Excel 2003

Can someone inform me how to put Month, date, year and day of the week in
cell. I'd like to insert for example, 05/18/06 Wed

how to insert month date year and day of week
 

Beautiful, thank you so much

Sachi from Japan

"bj" wrote in message
...
<format<cells<number<custum
enter
mm/dd/yy ddd

"Sachi Noma" wrote:

I use Win XP Home Edition, SP2, Excel 2003

Can someone inform me how to put Month, date, year and day of the week in
cell. I'd like to insert for example, 05/18/06 Wed