How can be done?
 

How can I format as such == "Tuesday: May 18, 2004 - 14:45 PST"

THI

How can be done?
 

Sophia

try a Custom format like:

dddd: mmmm dd, yyyy - hh:mm "PST"

Regards

Trevor


"Sophia" wrote in message
le.rogers.com...
How can I format as such == "Tuesday: May 18, 2004 - 14:45 PST"

THI

How can be done?
 

Main menu: Format--Cells--Number Tab--Select Custom in
category--select Type box and paste:
dddd": "mmm dd, yyyy" - "hh:mm" PST"

Sophia wrote:

How can I format as such == "Tuesday: May 18, 2004 - 14:45 PST"

THI

How can be done?
 

Fomrat / Cells / Date / Custom dddd: mmm dd, yyyy - hh:mm "PST"

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------



"Sophia" wrote in message
le.rogers.com...
How can I format as such == "Tuesday: May 18, 2004 - 14:45 PST"

THI




---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.686 / Virus Database: 447 - Release Date: 14/05/2004

How can be done?
 

Ken Wright wrote:
Fomrat / Cells / Date / Custom dddd: mmm dd, yyyy - hh:mm "PST"


Thank you all,

It works with =NOW() + the format above