Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc,microsoft.public.excel.newusers,microsoft.public.excel.worksheet.functions
Sachi Noma
 
Posts: n/a
Default 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


  #2   Report Post  
Posted to microsoft.public.excel.misc,microsoft.public.excel.worksheet.functions,microsoft.public.excel.newusers
bj
 
Posts: n/a
Default 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



  #3   Report Post  
Posted to microsoft.public.excel.misc, microsoft.public.excel.worksheet.functions
JimMay
 
Posts: n/a
Default 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


  #4   Report Post  
Posted to microsoft.public.excel.misc,microsoft.public.excel.worksheet.functions,microsoft.public.excel.newusers
Sachi Noma
 
Posts: n/a
Default 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




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 11:22 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"