How can be done?

Sophia · May 18, 2004

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

THI

Trevor Shuttleworth · May 18, 2004

Sophia

try a Custom format like:

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

Regards

Trevor

JWolf · May 18, 2004

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

Ken Wright · May 18, 2004

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

Sophia · May 19, 2004

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

Thank you all,

It works with =NOW() + the format above