Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Computing > Computer Support > Help with Excel 2003

Reply
Thread Tools

Help with Excel 2003

 
 
BIGEYE
Guest
Posts: n/a
 
      12-10-2005
I want to format a cell to display the date in this format:
Sat, Nov 10, 2005.
Is this possible?
TIA


 
Reply With Quote
 
 
 
 
Swiss Tony
Guest
Posts: n/a
 
      12-10-2005

"BIGEYE" <address@is[invalid].ok> wrote in message
news:439b21b1$0$29577$(E-Mail Removed)...
> I want to format a cell to display the date in this format:
> Sat, Nov 10, 2005.
> Is this possible?
> TIA
>
>


Click format
Click cells
Under the numbers tab in the catagory box, click custom
Enter ddd,mmm dd,yyyy in the box.
In the cells u have formatted, enter info in the following format 10/11/05


 
Reply With Quote
 
 
 
 
Michael pick
Guest
Posts: n/a
 
      12-10-2005
yes,
on your spreedsheet click on format,
cells, top left, number then custom on the drop down
box.

"BIGEYE" <address@is[invalid].ok> wrote in message
news:439b21b1$0$29577$(E-Mail Removed)...
> I want to format a cell to display the date in this format:
> Sat, Nov 10, 2005.
> Is this possible?
> TIA
>
>



 
Reply With Quote
 
James
Guest
Posts: n/a
 
      12-10-2005

"BIGEYE" <address@is[invalid].ok> wrote in message
news:439b21b1$0$29577$(E-Mail Removed)...
>I want to format a cell to display the date in this format:
> Sat, Nov 10, 2005.
> Is this possible?
> TIA


Format the cell as " ddd mmm d yyyy "

ddd = sat
mmm = november
d = 10
yyyy = 2005


 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Problem with Excel reports ::::Excel 2003 Migration To Excel 2007 =?Utf-8?B?c2hhc2hhbmsga3Vsa2Fybmk=?= ASP .Net 15 10-24-2007 01:34 PM
Help with Server 2003 x64 and Exchange 2003 install - deploy block =?Utf-8?B?VG9tIERpZw==?= Windows 64bit 2 03-20-2006 06:55 PM
exporting an excel file from database; making changes to excel file and updating the database by importing it back Luis Esteban Valencia ASP .Net 1 01-12-2005 12:28 AM
Help Me!! Cannot Create Web Projects on Windows Server 2003 with VS.NET 2003 Juan T. Llibre [MVP] ASP .Net 4 12-09-2004 02:14 AM
Excel _WorkBook vs. Excel.Workbook =?Utf-8?B?SmltIEhlYXZleQ==?= ASP .Net 1 09-29-2004 03:48 PM



Advertisments