Easy Excel, now() 1

[rnordquest]

="Date Printed: " & now() gives text and serial number

= now() gives date and time i.e. 5/9/2009 10:36


How do I format the text equation to give me this:

Date Printed: 5/9/2009 10:36

 

[electricpete]

="DATE PRINTED:" &TEXT(NOW(), "mm/dd/yyyy HH:SS")

=====================================
Eng-tips forums: The best place on the web for engineering discussions.

 

[rnordquest]

Thanks. It was the d-quotes that I didn't know.