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

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

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

"Sachi Noma" <[email protected]> wrote in message
news:[email protected]:

> 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

Beautiful, thank you so much

Sachi from Japan

"bj" <[email protected]> wrote in message
news:[email protected]...
> <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
>>
>>
>>