How can be done?

[Sophia]

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

THI

 

[Trevor Shuttleworth]

Sophia

try a Custom format like:

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

Regards

Trevor

 

[JWolf]

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

 

[Ken Wright]

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

 

[Sophia]

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

Thank you all,

It works with =NOW() + the format above